In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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