Summary:
This article details the issue related to a #NAME? result on a SUM Formula when rendering.
Article Sections
Symptoms:
When running a report that uses total formulas (ex: SUM), if you have totals that do not return results they can have an Excel "#NAME?" result.
Cause:
No result returned when rendering the report.
Resolution:
To alleviate this issue you can use an IFERROR Statement.
For example:
Instead of =SUM(OSRRef(F6)) you can replace this with =IFERROR(SUM(OSRRef(F6)),0).
Doing so will correct this and look something similar to the below:
Properties:
Report Designer
Cloud
Private Host
BI360