SAP Knowledge Base Article - Public

3439184 - Currency on Numeric Point Showing After Measure

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

  1. Open Story
  2. 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

Product

SAP Analytics Cloud 1.0