#NAME? on SUM Formula When Rendering No Data

Summary:

"#NAME?" result on SUM Formula when rendering.

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:

References:

Properties:

Applies To:

• Report Designer all versions