Essbase Error (1200494): Error executing formula for [REGION DEFINITION] (line 0): Recursion [31] r
I'm building a formula which needs to calculate based on the results of a preceding member calculation.
The first calculation for [Gross Return rate - blended month] is assigned solve order of 2 and has the following formula:
case when contains([ACCOUNTING_PERIOD].currentmember,[PER.1]:[PER.12]) THEN
coalesceempty([grossReturn.Month]/([FI - Capital]+[FI - Beginning Balance Calc]),0)
ELSE
([Gross Return rate - blended.Month],[ACCOUNTING_PERIOD].CURRENTMEMBER.LASTCHILD)
END
The above calculates correctly in my test data, the problem occurs as soon as I try to use this calculated member in a new calculation. I make sure that the new calculation uses a solve-order of 3. Even if I just want to return the value of [Gross Return rate - blended month] from a previous month it triggers the recursion error.