Reconciling the amount

[Tid14]

Hi, I am preparing a workflow in which I need to reconcile certain amounts on the basis of claim numbers.

I have attached an example below

The approach I was following earlier was I was using summarize grouping it by claim number and taking sum of amounts, and then filtering out the sum which are 0.

But t I guess this will not work in this case as 1 Claim number and amount will be left over and sum will not be 0.

Any help on how to resolve this?

Thanks in Advance :)

[binuacs]

@Tid14 @Can you provide the expected output as well