Symptom
- Incorrect scale used.
- Expect the scale used for the number, to be different than the one automatically selected in SAP Analytics Cloud.
- Measure set to be automatically formatted using the scale: Thousand, Million, Billion, does not scale as expected in SAP Analytics Cloud.
Environment
- SAP Analytics Cloud
Reproducing the Issue
- In SAP Analytics Cloud, create a Story
- Add a Chart, or widget, on which you add a Measure.
- In Styling, set the Number Format to:
- Scale : Auto-formatted
- Scale Format: Thousand, Million, Billion
- When viewing the Story, some Measure scale to Thousand, when expected to see it to scale in Million
Example:
- The value : 1,234,560
- Display as : 1,234.56 Thousand
- The expectation is to scale to Million, like: 1.23 Million
Cause
- In SAP Analytics Cloud, when setting the Scale to "Auto-formatted", it is designed to scales the value based on the following rules:
- Unformatted : values < 10,000
- Thousand : values < 10,000,000
- Million : values < 10,000,000,000
- Billion : values >= 10,000,000,000
This is why a value like: 1,234,560
Will be formatted using the scale: 1,234.56 Thousand
Because the value is greater than 10,000, and smaller than 10,000,000
To be formatted using the Million, the value needs to be equal to, or greather than 10,000,000,000
Resolution
- The Auto-formatting scaling works as expected in SAP Analytics Cloud, but if you want to always display the value using Million, set the scale to Million, or the specific scale desired, instead of using the Auto-formatting scale.
See Also
- 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 case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
Keywords
SAC , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0