I have a unitprice column. In my report if the prodcode is like "*elev*" I need the unitprice to equal 0.00
Here is the expression I am using. It doesn't work. I don't receive an error, it just seems to be ignored. Is there something wrong with my expression?
=iif(Fields!ProdCode.Value LIKE "*elev*", 0.0,Fields!UnitPrice.Value)