selecting all Amount netting to zero

[joshikalyani]

I attached the data, where i'm trying to get the all amounts which are netting to zero

amounts can not be in sequence

eg, netting amount can not be from consecutive rows

[gautiergodard]

Hello @joshikalyani 

Would you be able to provide an example or two of what you're looking for?

[joshikalyani]

eg. netting to zero

Amount

-3,925,397,461.42

3,925,397,461.42

-286,867,962.49

286,867,962.49

2. if combine diffrent values like below, then if there is netting entry for the total 39,334,652.13 that one should be searched in output

-19,873,874.17

-19,460,777.96

-39,334,652.13   Total

[gautiergodard]

OK thank you, and is the ID column relevant here?

[joshikalyani]

Yes, it is. but for now will check the scenarios irrespective of id.

[gautiergodard]

I think something like this could work for you use case.

After running this workflow you'd just have to filter out the consecutive rows that equal 0.

** Please like this post and mark this thread as resolved if this solved your question **

[joshikalyani]

Thank you🙂

After filtering the totalof amount is not netting to 0. 

Can you please help in netting amount to 0 by the same id? 

I need both outputs in different sheets, one which is without considering ID(as above output) & other with considering ID.

[joshikalyani]

I grouped with ID, but the output for ID 184 is netting to 0, but others are not netting to 0.

Please suggest if anything else is required

Thank you

[gautiergodard · Accepted solution]

Hi @joshikalyani 

In an earlier post, you'd mentioned the ID column wasn't relevant.

If you looking to group by IDs and find the net amount of each ID, you can achieve this with a summary tool configured like the below:

[joshikalyani]

In the above scenario, can we add one more condition,

- if difference between the two amounts is 20 then can also be flagged yes