Suppress When Value is Null on Calculated Dimension - Options

[Anonymous]

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?

[perumal_41 · Accepted solution]

Hi,

Try this expression in Dimension

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

Regards

Perumal A

[Anonymous]

Thanks!