Hi
I'm trying to match on the following - Currency must be the same, Origin must be opposite, Amounts must be opposite directions but can be within 1% tolerance. Could anyone help?
Currency | Origin | Amount | Match ID |
USD | Our | 50 | 1 |
USD | Their | -50 | 1 |
AUD | Our | 100 | 2 |
AUD | Their | -99 | 2 |
BRL | Our | 20 | 3 |
SAR | Our | -20 | 4 |
Solved! Go to Solution.
I'm assuming you mean you want to create something like the Match ID field you have in the screenshot? But maybe I'm misunderstanding.
If so, you might try something like:
Thank you @cplewis90 !! I tried this before seeing your solution in such a roundabout way and your solution worked a treat in a few steps