SAP Knowledge Base Article - Public

2956844 - Applying Percentage formatting multiplies a value by 100 in SAP Analytics Cloud (SAC)

Symptom

 Applying Scale - Percentage to a value multiplies it by 100

Environment

  •  SAP Analytics Cloud (Enterprise) 2020.8.22

Reproducing the Issue

  1. Having two Measures i.e: X = 100 and Y = 30
  2. Create a Calculated Measure Z = Y / X * 100 that calculates the percentage of Y / X
  3. Insert in the story the Calculated Measure Z, the value will be shown as 30  
  4. Apply formatting: Percentage, the value will be displayed as 3000%

Cause

  • This behavior is by design: the Calculated Measure Z should be not multiplied by 100, because applying the Percentage formatting will multiply the value by 100

Resolution

Do not multiply by 100 Calculated Measures that are percentage values:

  1. Having two Measures i.e: X = 100 and Y = 30
  2. Create a Calculated Measure Z = Y / X that calculates the percentage of Y / X
  3. Insert in the story the Calculated Measure Z, the value will be shown as 30  
  4. Apply formatting: Percentage, the value will be displayed as 30%

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, percentage, formula, format
, KBA , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , How To

Product

SAP Analytics Cloud 1.0