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
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:
Hello @joshikalyani
Would you be able to provide an example or two of what you're looking for?
eg. netting to zero
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
Yes, it is. but for now will check the scenarios irrespective of id.
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 **
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.
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
In the above scenario, can we add one more condition,
- if difference between the two amounts is 20 then can also be flagged yes
Hey @joshikalyani
You could do something like this!
**Please like and mark this thread as resolved if this provided the answer to your problem**
For the netting zero solution , it is working on consecutive rows only , I've attached excel where it is taking first 2 netting records but not other two.
Highlighted in green 4 records
@joshikalyani the difficulty here is there doesn't seem to be any pattern or way to group/sort your data set to apply a consistent logic. Attached is an option for sorting in a consistent manner based on whether the absolute value of a number and whether it's positive or negative.
Thanks, but it still missing other 2 matches
