Filter based on summed column

[TJ2]

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?

[grossal]

Hi @TJ2,

you could achieve this using a Filter Tool:

Input:

Setting:

Output:

Sample workflow attached.

Best

Alex

[TJ2]

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.

[grossal]

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:

Input:

Summed up:

Filtered (T-Anker):

Updated workflow attached. Is that what you are looking for?

Best

Alex

[TJ2]

I think it's getting close. The summarize tool can identify what categories totals to zero, however I need all of the unsummarized data (all the other fields in the table) to process further in the workflow.

So my table contains >1M records. I only want to pass through all of the records where the sum total of the categories are not zero. So using your example only want all of the records for Categories A,C,D. to remain because the sum of all the records do not equal zero.

[grossal · Accepted solution]

Ahh, I think I finally got what you want.

Output:

Updated workflow attached.

Best

Alex

[TJ2]

That's it. Thanks!

[grossal]

Sorry that it took so long, my brain slows down in the evening :')