I'm displaying data in a straight table in which I need to suppress rows with Quantity values of zero as well as Unit Price values that display as 0.00. The "Suppress Zero-Values" did not work for this so I've made the following entry in my dimension to hide rows with Quantity = 0, which works perfectly:
=if([Transactions.Quantity]>0, [Customer.Sales Rep Full Name] , Null())
However, when I use the same logic with the Unit Price value, rows are not suppressed at all OR all rows are suppressed (depending on which method below is used).
The following does not suppress anything:
=if([Transactions.Unite Price]>0, [Customer.Sales Rep Full Name] , Null())
I have tried the following checking for NULL instead (incorrectly suppresses all rows):
=if([Transactions.Unit Price]<>Null(), [Customer.Sales Rep Full Name] , Null())
Also tried checking for NULL the following way, using "len" (incorrectly suppresses all rows):
=if(len([Transactions.Unit Price]>0), [Customer.Sales Rep Full Name] , Null())
