5 Replies Latest reply: Dec 23, 2015 5:54 AM by Marcus Sommer RSS

    Pivot table - how to get rid of "0" zero values, using script.

    Jim Chan

      HI guys,

       

      i am working on a pivot table. somehow, my expression column, has "0" values, and my client doesn not need to see the "0" zero value.

       

      As first , my code of line is as such 'Sum({$<FCODE={"TP01"}>}QTY)' . So, i thought i could have just add a IF statement as such 'if(QTY>0,Sum({$<FCODE={"TP01"}>}QTY))' then will be able to get rid of those "0" value.

       

      Unfortunately , nope! so.. how should i write?

      error.png

       

      rgds,

       

      jim