Support Article
Null values display as 0 in Excel
SA-87055
Summary
Empty values remain empty when results display on running a report with decimal values.
The null values change to 0 on exporting the report to Excel. The null values must remain null.
Error Messages
Not Applicable
Steps to Reproduce
- Create a report definition
- Add Integer property and Decimal property to the report definition
- Run the report definition. The Integer and Decimal properties with no values display as blank
- Perform Export to Excel. Blank values are replaced by zero
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Apply HFix-55908.
Published September 6, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.