Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Create Average ignoring NULLs & 0s in SAP Analytics Cloud

|| 1

Create Average ignoring NULLs & 0s in SAP Analytics Cloud
Stechies

How to create Average which ignores NULLs & 0s in SAP Analytics Cloud (SAC)?

Hello SAP Experts,

I want to create an Average in SAP Analytics Cloud which ignores all NULLs and 0s. 

Please, can anyone explain me step by step procedure?

Thank in advance.


Comments

  • 11 Apr 2018 7:08 pm Best Answer

    Hello,

    Please follow steps below in order to create an Average in SAP Analytics Cloud (SAC):

    1) First, open your SAP Analytics Cloud Model via (Browse > Models)

    2) Then click on 'Account' tab

    3) Now you need to add a new row to account:

    • ID=MyAverage
    • Description=MyAverage
    • AccountType=NFIN
    • Exception Aggregation Type=AVG excl. 0, NULL
    • Exception Aggregation Dimension=Dimension(s) Over Which Average Is Valid
    • Formula=[Account/Measure To Average]

    4) Now please save the model

    5) Make sure to use MyAverage in your Story


Advertisement
Advertisement