I am having problems testing for zero values

iif([Measures].[Cost]=0,0,1

If the cost is null (empty), then the "0" shows up. If the cost is $0.00, then the "1" shows up, which is wrong

Cost is a measure that comes from the datbase directly. It is defined in SQL server as "decimal" with "20" precision and a scale of "2". It has a Data Type of "Double" and format of "Currency" in OLAP

Any thoughts

Hello
tr
iif(clng([Measures].[Cost])=0,0,1

HT
Jör