SAP Knowledge Base Article - Public

3060900 - Incorrect totals of rounded values in SAP Analytics Cloud (SAC) and SAP Digital Boardroom

Symptom

Incorrect Totals for values rounded in SAC stories based on a Live Data Connection.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.7.7
  • Live SAP HANA Data Connection

Reproducing the Issue

  1.  Create a calculation view in HANA DB, that rounds the values of a measure i.e. ROUND_SALES = ROUND(SALES,0) 
  2.  Create a Story in SAP Analytics Cloud, based on the above HANA calculation view
  3.  Insert a table with dimension and the rounded measure i.e. COUNTRY and ROUND_SALES
  4.  Observe the totals: they may not seem correct i.e.:
           
    COUNTRY SALES ROUNDED 
    ARGENTINA                                     150,761
    BRAZIL                                     145,081
    CANADA                                     345,515
    TOTAL                                     641,357
         

Cause

  • The totals are correct, because they are returned from the Live Data Connection 

In this example, the data in the backend is:

COUNTRY                            SALES                     SALES ROUNDED 
ARGENTINA                   150,760.92                                     150,761
BRAZIL                   145,080.70                                     145,081
CANADA                   345,514.63                                     345,515
TOTAL                  641,356.25                                     641,357
  • Therefore, the total may not seem correct however it is the representation of the real sum of all the individual values.In this case the total is ROUND(641,356.25,0 ) which is  641,356

Resolution

The behavior is by design.

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

Product

SAP Analytics Cloud 1.0