I have created a HFR and the users want to use it in exported Excel format as they have a few existing excel reports against which they want to compare Hyperion report.
The issue is with the Percentage values. When HFR are exported, the percentage values comes out as "Custom" excel Number format instead of "Percentage" Excel Number format.
When the users try to compare the Hyperion report with Existing excel % values, it gives them wrong numbers.(As 97% in "Custom" Excel Number format is equal to 9700% in "Percentage" Excel Number format.
Any solution to export the report in Excel and show percentage values in "Percentage" excel Number format instead of "Custom" format ?