SAP Knowledge Base Article - Public

3290116 - When totals exceed 14 digits in stacked chart types, the values get rounded in SAP Analytics Cloud (SAC)

Symptom

For stacked chart types (Stacked Bar/Column, Combination Stacked Column & Line, Marimekko), when the totals value exceeds 14 digits it will get rounded and hence appears to be no longer precise.

chart1.pngchart2.png

Environment

  • SAP Analytics Cloud (Enterprise) 2022.21

Reproducing the Issue

  1. Create a new Stacked Bar/Column, Combination Stacked Column & Line, Marimekko
  2. Add one or more measures with big values, such that the stacked total values displayed on top, or bottom of a bar or column exceed 14 digits
  3. Notice the total value is not a precise sum of all the numbers in the stack

Cause

This behavior is by design with Highcharts

Resolution

Floating points numbers need to be converted to a specific precision for sum calculation(in this case 14 was chosen by the charting library) to avoid JavaScript numeric errors such as 0.1+0.2 != 0.3.

See Also

Your feedback is important to help us improve our knowledge base.

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, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0