Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Reconciling the amount

Tid14
8 - Asteroid

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 :)

 

 

 

 

1 REPLY 1
binuacs
21 - Polaris

@Tid14 @Can you provide the expected output as well

Labels
Top Solution Authors