3300177 - SAC AD : Error "The operation in the formula operator is invalid" when trying to enter values to perform planning on Time hierarchy

• 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 - All versions

• 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?
• 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

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