Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try this expression in Dimension
=if(CustomerID=0,null(),if(CustomerID<>(CounterPartID),CustomerID,null()))
Regards
Perumal A
Hi,
Try this expression in Dimension
=if(CustomerID=0,null(),if(CustomerID<>(CounterPartID),CustomerID,null()))
Regards
Perumal A
Thanks!