Symptom
- Calculations in Charts shows unit after the number, regardless of the system and user settings.
- System and User settings have set the unit to show before the numbers.
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Open Story
- Formulas in charts show the units after the number, where it should be before the number
Cause
Product Behavior is by design
Resolution
Currency Formatting is based on the various settings applied:
Setting which is respected as the following: Widget Settings > Calculation Settings > Profile Settings > Tenant Configuration
The changes made in Profile settings will apply for default measures only. But calculations will not respect it if the format settings are changed at the calculation level.
The currency position set in profile settings will apply only for the currency symbols, but in calculations Units are being used.
Units can be of any string type (not only the currency symbols), hence the currency settings cannot be applied to unit type in calculations.
To retain the currency position User has to either enable the "Use unit of underlying measures" option with currency type declared at model level
or
use an option to change to percentage format in calculation format settings to use % at the end of the value
Keywords
Chart Units, Unit Formatting, Unit Position, Numeric Point, SAC, SAP Analytics Point , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem