This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to build a logic, but have no idea how to do it in Alteryx.
At the same customer number and purchase order number level, I want to off set the credit memo to the invoice if the amount added up are within the range from -$0.5 to $0.5...
For example, in below example, all items under same customer 100020 and PO No. 10093 or 10091. The same color highlighted two items are the ones I am looking for with the expected result. what would be a good logic to set up a calculation in Alteryx to achieve that? My goal is to have an list of potential offset items with below columns ( The original data columns are in the screen shot)
CM _ NO.
I have nowhere to start, any help is very much appreciated!