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
Solved! Go to Solution.
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.
Thanks for the response @benjamin_feuchter . I appreciate it so much.
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |