Issue
Percentage field values display incorrectly in the exported Microsoft Excel file of the Insight.
Symptoms and Impact
Percentage field values in the exported Excel file do not match the values shown on the Insight.
Steps to Reproduce
1. Create an Insight with a percentage field column.
2. Export the Insight to Excel.
3. Check the percentage values displayed in the Excel file. The values in the percentage column are not the same as those displayed on the Insight.
Root Cause
This issue has been identified as a bug.
In the Traditional UI, it is recommended to input decimal values, such as '0.25' for 25%. These values are saved in the Pega Clipboard as 0.25. However, when displaying the field, for example, in the Details View, the value is multiplied by 100 and shown as 25%.
When exporting data in Insights to Excel, the values are taken directly from the database and put in the Excel file. A value of .25 for "25%" is put directly in Excel as .25 when Excel formats as a number. When Excel formats as a percentage, then internally Excel will display as 100*numeric value, or "25%".
In Constellation, percentage values are input as 25, stored in the Pega Clipboard as 25, and displayed as 25%. However, since the logic for exporting data from Insights has not changed, when Excel formats as a percentage, Excel will display as 100*numeric value, or 2500%, which is not expected.
Solution
This issue is addressed in Infinity '25.
For users on Infinity ’24.1 and '24.2, please note that this known issue document will be updated when a patch with the fix becomes available for those versions.
References
Configuring Decimal, Integer, and Percentage fields
Creating a data type in Dev Studio