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

    Suppressing null values-expression



      I have a straight table.



      Dimension: Product code



      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?