2527989 - Details cannot be calculated on IF formula in SAP Analytics Cloud (BOC)

The following error occurs in the SAP Analytics Cloud modeler when saving a formula with the "Calculate on details" feature / 'Details()' keyword:

• Details cannot be calculated on IF Formula

This error may also appear when you open a story referencing an account / measure that uses the "Calculate on details" feature / 'Details()' keyword:

• An error occurred while executing the query. No changes were made and the previous state is now restored.
• Caught exception: exception 70034011: Inconsistent calculation model\$message\$=Inconsistent calculation model;calculationNode (N_0007_AGR) -> attributes ->attribute
  (R_[sap.epm:Account].[parentId].&[Round]__SignedData) -> expression:Expression is not valid: Evaluator:type error in expression evaluator;fixed16_24.7 fixed_16([here]round(fixed16_24.7 "R_[sap.epm:Account].[parentId].&[700000]__SignedData",decfloat '2'))

• SAP Analytics Cloud

• Do not use the formula with the "Calculate on details" feature / 'Details()' keyword as it will be deprecated / not supported.
• Instead add the exception aggregation 'SUM' with all required dimensions as exception aggregation dimensions.
• See the following article on Exception Aggregation in SAP Analytics Cloud: Applying Aggregation in SAP Analytics Cloud

• 2448851 - Formula calculation not refreshed in SAP Analytics Cloud
• Price * Volume Formulas
• How to find User Assistance for SAP Analytics Cloud?
• Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

Your feedback is important to help us improve our knowledge base.

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 , calculate on details , impossible d'utiliser la "fonction , détail" dans les formules du modèle , impossible d'utiliser la "fonction détai , "fonction détail" dans les formules du m , modèle , detail, detailed details , 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