I have a column in SSRS report which should be displayed in currency format. The data which is returned from dataset is of string datatype and it contains hyphen("-") character as well.
I am using below expression.
=IIF(Fields!PREMIUM.Value="-","-",CDbl(Fields!PREMIUM.Value))
My intention is if the value is "-" then am ignoring it, otherwise am converting the string value to double.
Note: The textbox properties is already set to currency format.
The expression is working if there is any value other than "-"
This is the output. #Error is displayed
