Sum a Total Without Including the Negative Value

Question

Hi guys,

I would like to seek your help in line to the following scenario. I would like to sum a certain column wherein it would only give me all the positive values ignoring the negative values. Please advise what formula or action should I used to acquire this solution. See sample table below.

Looking forward for your help on this matter.

Thanks,

Kamen

benjamin_feuchter · Accepted Answer

Hi Kamen, one way you could this would be applying a formula tool to replace the negative numbers with 0s (e.g. by using this expression: IF [COLUMN] >= 0 THEN [COLUMN] ELSE 0 ENDIF) and then use a summarize tool on this column with the "Sum" action.