16 Replies Latest reply: Jun 9, 2016 2:10 PM by Tracey Sacks RSS

    Cant hide nulls in straight table

    Matt Patterson

      I have a straight table with two columns, a dimension and an expression.

       

      Dimension: Versionname

      Expression: =IF((Versionnum-Above(Versionnum) = 1) OR ([Versionname] = 'V100001'),NULL(),'Check')


      Output


      Versionname    Expression

      V100001         

      V100002         

      V100003         

      V100004         

      V100007          Check

      V100008         

      V100009         

      V100010         

      V100011         


      What I want is to only output the rows that aren't NULL


      Expected output


      Versionname    Expression

      V100007          Check



      I have ticked "Suppress when value is null" in the Dimensions tab.

      I have ticked "Suppress zero-values" and Suppress missing" in the Presentation tab.