I am writing a report in SSRS and getting the following error for an expression I'm trying to write: [rsRuntimeErrorInExpressio
n] The Value expression for the textbox OEPeriodOne contains an error: Input string was not in a correct format.
What I'm trying to do is provide sales dollars by period so there are periods on the report that don't have data yet. I have included the code that I'm using. When there is no data for the period the code is fine, but when there is data for the period I get the above error.
Any help would be great. Thanks.
=iif(Fields!OEPeriodFive.Value = "", FormatCurrency(0, 2), FormatCurrency(Fields!OEPeriodFive.Value, 2))