Null values display as 0 in Excel
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.
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
A defect in Pegasystems’ code or rules.
Published September 6, 2019 - Updated December 2, 2021
Was this useful?
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.