8 Replies Latest reply: Aug 31, 2015 11:27 AM by Ade Shokunbi RSS

    Straight table displaying null values

    Ade Shokunbi

      I have a straight table that I don't want displaying null values.  I read a comment that said I can control the value I don't want displayed by making the dimension suppress null values and make expression values I don't want as null values so I have the expression below:

       

      If(1-MAPE >.70,null(), 1-MAPE)

      The column is displaying values less than 70% and setting values higher than 70% as null, -, but I don't want it to display the null values period.  Please help.