Skip to Main Content

HFR - Exported in Excel custom Number formatting issue

3222337May 6 2016 — edited May 9 2016

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 ?

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jun 6 2016
Added on May 6 2016