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
Comments
0 comments
Please sign in to leave a comment.