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

      =if(CustomerID=0,'-',if(CustomerID<>(CounterPartID),CustomerID,)'-')

       

      But I have also tried the following

      =if(CustomerID=0,'',if(CustomerID<>(CounterPartID),CustomerID,)'')

       

      =if(CustomerID=0,'0',if(CustomerID<>(CounterPartID),CustomerID,)'0')

       

      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?