Summarize Tool / Formula Tool

[phemala1]

I Have a input data, if a sum of particular reference nets to zero then that line i wanted to exclude to proceed further steps. Can i use summarize or which tool would be ideal for removing sum of a reference with nets to zero.   

i have attached the workflow, if the sum of PO column is nets to zero then i want it be removed from the output.  can anyone advice me ASAP I have a project to be submitted tomorrow.

Thanks a lot for your help in advance.

[afv2688]

Hi @phemala1 ,

this workflow eliminates the colums which have sum = 0

cheers

[phemala1]

Thanks for your response, I will try this and comment. Thanks:)

[phemala1]

i want the entire row to be eliminated if two are many row put together nets to zero, will this work out with the above work flow you have provided (eliminate column).

[afv2688]

Hi @phemala1 ,

I'm sorry I cant get what you mean. Could you please create a dummy input and output on a table here to illustrate your needs?

Cheers

[phemala1]

i have attached the excel, i have PO_ID in column I and value in column AA. There will be a positive line in a row for the PO_ID and negative line in another, if the sum of PO_ID nets to zero then both the rows (positive and negative) has to be removed from the output.

In the attached excel first two rows has this case, Kindly advice. 

[afv2688 · Accepted solution]

Hi @phemala1 ,

I think I managed to do what you asked me to using your file.

cheers