SAP Knowledge Base Article - Public

2596418 - Calculated account does not aggregate in SAP Analytics Cloud (SAC)


Create a calculated account cKPI based on the values of another account KPI.

Whenever there is an KPI value of larger than 0, the cKPI should be calculated as 1.

The formula works fine when drilling down on dimensions, but the system is not able to aggregate it.

It returns the error message: "System could not calculate a value for unknown reasons".


  • SAP Analytics Cloud 2018.1.9


This might be a limitation as per this help page:

The formula applies only to the member level where you added the formula; it doesn't apply to parent members.

These features are not supported at this time:

>> Flat date hierarchies


Also, If you use the formula in a chart, the dimensions that you used in the formula must be added to the chart.


In order to get data for account members with IF formulas that use dimensions, without including those dimensions in drill, it is necessary to define an exception aggregation on the account member using a superset of the dimensions used in the IF formulas.

See Also


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 , KBA , reporting of calculated account not poss , not possible , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem


SAP Analytics Cloud 1.0