RD PH/Cloud Issue: #NAME? on SUM Formula When Rendering No Data

Summary:

This article details the issue related to a "#NAME?" result on a SUM Formula when rendering.

Article Sections

• Symptoms:
• Cause:
• Resolution:
• Properties:

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:

Applies To:

• Report Designer all versions