Symptom
- Calculated percentage values are displayed correctly in the report designer but lose the percentage format when exported with "scope: All".
- When exported with "scope: All" and "Include Formatting" checked, percentage values appear as long decimal numbers (e.g., 109.5% appears as 1.0949901).
- When exported with "scope: Point of View" and "Include Formatting" checked, the percentage format is retained (e.g., 109.5% appears as 109.5%).
Environment
-
SAP SuccessFactors Platform
Reproducing the Issue
- Navigate to the Report Center.
- Open the Story report.
- Verify that the measure is formatted as a percentage in the report designer.
- Export the table with the following configurations:
- **Scope: All**
- **Include Formatting: Checked**
- Observe that the values are exported as long decimal numbers (e.g., 1.0949901).
- Export the table with the following configurations:
- **Scope: Point of View**
- **Include Formatting: Checked**
- Observe that the values are exported correctly with percentage formatting (e.g., 109.5%).
Cause
The behavior is actually by design and represents a known limitation in our current system architecture. Specifically:
- When exporting data with scope set to "all," the system maintains only the formatting that is defined at the model level
- Formatting that is defined within the story context (such as your story calculation percentage formatting) is not preserved during the export process
- This explains why your percentage column appears as decimal values in the exported file, even when "include formatting" is selected
Resolution
This limitation exists because story-level formatting (including story calculations) operates at a different layer than model-level formatting. The export functionality with "all" scope currently only has access to and preserves the underlying model formatting definitions.
See Also
- Refer to: 2088892 - How to Grant Support Access to SAP SuccessFactors Support Staff
- Refer to: 3363126 - How to show percentage (%) in story report
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
percentage export issue, story report percentage, scope all export, include formatting, sap analytics cloud export, calculated measure percentage, export formatting issue, sap successfactors people analytics, story report export issue, percentage field export, export scope all, export scope point of view, sap analytics cloud story report. , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , LOD-ANA-UNS-EXP , Unified Story PDF/PPT/Excel/CSV Export , Problem
SAP Knowledge Base Article - Public