3300177 - SAC AD : Error "The operation in the formula operator is invalid" when trying to enter values to perform planning on Time hierarchy (LOD-ANA-AD for SAC Analytics Designer)

• Formula error raised when user tries to enter value on collapsed half year time H1 & H2, to perform planning on Time hierarchy
  Error : The operation in the formula operator is invalid
  Correlation ID: 51178130-8103-4375-a091-121865716842
• In console, the error occurs :
  Code: 42422 Text: The operation in the formula operator is invalid
  

•  SAP Analytics Cloud (Enterprise) 

• When checking the model setting, the measure Amount_T (description is $) is a calculated measure and its formula is
  [Amount] | INVERSEIF([d/DATALABEL_O] =  "Forecast" or( [d/DATALABEL_O] =  "JulyForecast"and[d/Time].[p/QUARTERDESC]=("Q3", "Q4")and[d/Time].[p/HALFYEARDESC] =  "H2" ), [Amount]:= [Amount_T] *1 ).
• This issue does not happen when expanding the H2(2024) node. To narrow down the root cause, it is recommended to rewrite the formula of Amount_T (description is $) to the following two sentences :
  [Amount] | INVERSEIF([d/DATALABEL_O] =  "Forecast" or( [d/DATALABEL_O] =  "JulyForecast"and [d/Time].[p/HALFYEARDESC] =  "H2" ), [Amount]:= [Amount_T] *1 )
  [Amount] | INVERSEIF([d/DATALABEL_O] =  "Forecast", [Amount]:= [Amount_T] *1 )

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
• https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
• https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
• Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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

Formula, error 42422, operator invalid, Analytics Designer, planning time hierarchy , KBA , LOD-ANA-AD , Analytics Designer , Problem