Linked Questions

Popular Questions

SSRS currency formatting issue using IIF condition

Asked by At

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

This is the output. #Error is displayed

Related Questions