I'm trying to filter data based on if a summed amount from the table results the net remaining not equaling zero.
I need the data related to Category B,C & G to be eliminated from the workflow.
Any suggestions?
Ahh, I think I finally got what you want.
Output:
Updated workflow attached.
Best
Alex
Hi @TJ2,
you could achieve this using a Filter Tool:
Input:
Setting:
Sample workflow attached.
Another point, the summarized data represents the sum of >1000 rows of data. So I need to remove all records from the workflow in which the summed total of the same category equals zero.
Oh sorry, your sample did not provide multiple appearances of the same category, therefore I assumed you already summed it up.
I adapted the case:
Summed up:
Filtered (T-Anker):
Updated workflow attached. Is that what you are looking for?
