Hello all,
I'm working on recreating the formula from excel that helped me multiple times in finding postings which net each other out. Due to amount of data that I'm working on, excel is not enough and alteryx would prove to be much faster. In attached excel file, I have included exactly what I'm expecting from Alteryx output (colmun Net) - if result of formula is number then I can filter these postings out and their value will be equal to 0 (so they net each other out) and if results with error #NUM are selected then we get remaining population.
From usability standpoint I would expect some sort of dynamic selection from Alteryx that takes into the consideration all items in population rather than only for 16 rows as per in attached example.
Thank you in advance for all help :)
