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.
