SAP Knowledge Base Article - Public

3571197 - Error 'Exception Aggregation Type AVERGENULL, AVERGENULLZERO, COUNTNULL, COUNTNULLZERO requires a formula' in Exception Aggregation Type of Dimension Table in SAP Analytics Cloud (SAC)

Symptom

In Exception Aggregation Type of Dimension Table, the below error occurs:

'Exception Aggregation Type AVERGENULL, AVERGENULLZERO, COUNTNULL, COUNTNULLZERO requires a formula.'

Environment

SAP ANALYTICS CLOUD - 2024.21.14

Reproducing the Issue

 

  1. Login to this SAC
  2. Open a model.
  3. Under "Dimensions" click on "Edit Dimension Table" for a dimension.
  4. Notice the error message. 

    'Exception Aggregation Type AVERGENULL, AVERGENULLZERO, COUNTNULL, COUNTNULLZERO requires a formula.'

 

Cause

This issue when opening the dimension table is related to the Exception Aggregation type, specifically the AVG excl. NULL option. This option requires a formula to be specified mandatorily.

Resolution

To resolve this error

  1. Navigate to the modeler
  2. Select the affected model
  3. Under the workspace choose calculations and add a valid formula in the properties of the affected account members.

See Also

Keywords

exception aggregation type, averagenull, formula, dimension table, SAP analytics cloud , KBA , LOD-ANA-ML-CAL , Calculation Management , Problem

Product

SAP Analytics Cloud 1.0