Total in calculated column returns as 0 due to IF statement

[BeckersN]

Hi

I have a table with a calculated column to show current stock minus next 3 months forecast, with the goal of flagging which products have too much cover.

Some of these return a negative value, which is good as it means we don't have too much stock. To negate these results, I added an IF statement to return that result as 0 instead.

The issue I have now is that the total of that column was a negative amount and it now shows as 0 too, where I want it to show the sum of the positive values.

can I somehow exclude the Totals value from this?

[amitchandak · Accepted solution]

@BeckersN , You need to use sumx

return

Sumx(Values(Table[Column]), if(Result <0, 0, Result )

for more than one column

return

Sumx(Summarize(Table, Table[Column]), if(Result <0, 0, Result )