Hello Experts,
Could you please help advise how can I ensure that only those records move ahead with the all fields in the below data set, where the amounts net to zero.
Validation is to be done at column 'A/B' and column 'Amount' level.
Therefore, if 2 rows exist for the same amount, one with 'A' and other with 'B', the it can move ahead.
Amount will always be in absolute value.
| A/B | Code | Number | Amount | CCY | Desc |
| A | ABJ | 1 | 153.1 | USD | 2 |
| A | ABJ | 3 | 212.4 | USD | 4 |
| B | ABJ | 4 | 212.4 | USD | 3 |
