Sum only if positive

Mon, 14 Jun 2010 23:57:14 GMT

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 — Tue, 15 Jun 2010 00:29:30 GMT

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.

topic Sum only if positive in QlikView