2555779 - Average value not calculating correctly in SAP Analytics Cloud

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

SAP Analytics Cloud

This behavior is by design.

• 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.
• An enhancement request has been submitted to the 'Ideas Place' for future considerations on below link: https://influence.sap.com/sap/ino/#/idea/235384/?section=sectionComments

• Help resources and free SAP Analytics Cloud content
• Help portal
• SAP Community (Questions & Answers / Direct Link to ask question / Blogs)
• SAP Community WIKI
• Improvement requests (on the SAP Customer Influence portal)
• Video tutorials 
• Videos by topic areas: (Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration)
• Training events
• Past event recordings
• New user handbook
• Roadmap
• How to connect to on-premise data
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
• Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)

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.

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 (SAC) , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem