sum validation

[griseldagomes]

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

[adamweaver39]

Hi @griseldagomes, could you please explain a little more what you are trying to accomplish here? I am finding your description hard to follow. Making an educated guess -- I think you could try using the Multi-field binning tool in order to group by like numbers and then pass that through a filter.