SAP Knowledge Base Article - Public

3169309 - Pie and Donut Chart values don't add up to 100% in SAP Analytics Cloud (SAC)

Symptom

When using a pie or donut chart with percentage data labels, the totals may not always add up to 100%.  This issue can be more readily noticed when the number of decimal places for the chart is decreased to zero.

Environment

  • SAP Analytics Cloud (Enterprise) 2022.1.10

Reproducing the Issue

  1. Create a story with a Pie Chart
  2. Enable percentage data lables
  3. Note that the total of all the data labels may not add up to 100%

Cause

This issue occurs because when the number of decimal places shown is decreased, the accuracy also decreased.   Similarly when the number of decimal places is increased, the accuracy is increased, but results in less succinct data label values.

Resolution

This is by design.  If you create a Pie/Donut chart with three slices that are intended to be exactly 1/3 - which equals 33.33333...%.  When you use a lower number of decimal places (e.g., 0) the values are all rounded down to 33% and the total appears as 99%.

The expected behavior is to rely on rounding to show the calculated percentages and the App / Story designer needs to consider how important the accuracy of the values shown need to be versus succinctness of the data label values.

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0