Sum only if positive

[#1]

Hello,

I'm working with a table that has total order and total received. i created a calculated expression "total order - total received = open order".

However, there may be instances where the result is negative. how can i exclude negative values from my pivot table?

Thanks,

Sara

[johnw · Accepted solution]

Perhaps something like this?

sum(rangemax(0,"total order"-"total received"))

Or this?

sum(if("total order"-"total received">=0,"total order"-"total received"))

But for higher chart performance, you could instead do the if() in the script:

if("total order"-"total received">=0,"total order"-"total received") as "positive open order"

Then just sum("positive open order") in the chart.

Other approaches are possible as well.