9 Replies Latest reply: Jan 17, 2017 12:46 PM by Marco Wedel RSS

    Suppressing null values-expression

    Gemma Wilson

      Hi

       

      I have a straight table.

       

       

      Dimension: Product code

       

      Expressions:

      Sum(Free stock)

      Sum(Month 24)

      Sum(Month 25)

      Sum(Total Value 24 + 25)

       

      If Month 24 column has a value greater than 0 then I'd like it to appear in the table. If the value = 0 then I would not like the row to appear (even if there's data in the other expressions).

       

      I know there is "suppress null values" within a dimension, but is there the option for an expression?

       

      Please can you help?

       

      thanks