I have a report that contains a calculated field for Completion Rate % using the following code:
=IIF(Fields!ORG_REG_OPENINGS.Value>0,
Sum(Fields!COMPLETED_SLOTS.Value) /
Sum(IIF(Fields!ORG_REG_OPENINGS.Value>0, Fields!TOTAL_SLOTS.Value,0)),0)
When the end user views the report on the browser, this calculated field displays as expected. However, when it is exported to Excel, the column will show zeros instead of the expected % calculation.
Has anyone encountered such an issue before and do you know if it's an issue with Excel or Visual Studio?
Thanks, Denise
I tried exporting it to a different format (Word) and the issue resolved. However, it needs to be exported to Excel.