2555779 - Average value not calculating correctly in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2555779 - Average value not calculating correctly in SAP Analytics Cloud

Symptom

The average (AVG) value exception aggregation is not calculating correctly in SAP Analytics Cloud.

Environment

  • SAP Analytics Cloud 2017.21

Resolution

  • The average exception aggregation does not take into account null (empty) values.
  • You need to manually enter a zero value (0) in every member of the exception aggregation dimension that should be counted for the average and for every member of the dimensions defined in the table or chart.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, DrillMember, DrillState, , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0