2 Replies Latest reply: Mar 21, 2012 4:17 AM by Hamish Imrie RSS

    Suppress When Value is Null on Calculated Dimension - Options

    Hamish Imrie

      On a calculated dimension, the "suppress where value is null" option is not working.


      Has anybody else found this, or perhaps the syntax I am using needs amendment?


      I am using the following



      But I have also tried the following





      I am wondering what QV accepts as a null value, as all of the above statements return a value.

      Perhaps I need to use a different method?