14 Replies Latest reply: Dec 23, 2015 6:17 AM by akshay jain RSS

    Pivot Table, how to suppress Null Value in expression.

    Jim Chan

      I have created a pivot table. i have a column(Open Disc) showing 0 value.

       

      what i want is - do not show me any line of record if that line of record in "Open Disc" = 0.  only show me records that start from 1. And i have no idea how to achieve this.

       

      My existing code is as such:

      if(Sum({$<CTI_DESC1={"OPEN DISC (100%)"}>}QTY)=0,'', Sum({$<CTI_DESC1={"OPEN DISC (100%)"}>}QTY))

       

      I have came across, there are ppl proposed to use

       

      Sum( if(not IsNull(field), Amount) )

      Sum( {$<field={"*"}>} Amount )

       

       

      error.png

       

      Rgds

       

      Jim