Hello,
I have a complex scenario, in my opinion, where I need to highlight differently amounts which could be matched against each other to have their sum 0, but there can be multiple combinations. I tried to capture all of them in the examples below. The amounts are grouped by Cost type (Cost 1,2, etc), therefore amount of -100 from Cost 1 with amount of 100 from Cost 2 will not be a match.
Examples of match (from same cost):
-123 with 123
500 with the following amounts: -250 and -250
-1000 with the following amounts: 900 and 100
They might not be necessarily one row after the other one, therefore Multi-row formula could not be used (in my opinion).
I have highlighted in colors the output just to be easier for you to follow my logic, how they have been matched. In the final output, I just need the "Matching pair" column to confirm whether a match has been found or not.
I am also not sure if this is possible to be done in Alteryx, I am trying to figure out a way and would highly appreciate your suggestions. Also partial solution is accepted (some rows still to be manually checked and confirm either they are a match or not.
