Hello @Brj73 ,
It seems like you got a circular reference in the calculation of the line item. The meaning of that is that Anaplan cannot allow you to apply the desired syntax or else it will get in an infinite loop where there is not a defined solution given that the change of a line item keeps affecting the next.
My advice would be the following:
Alternatively, please share both formulas with us and we could assess further.
Hope that helped!
I am applying this formula in both the line item where i get circular reference error
Thanks for the images.
As you will see, the error is in the Override. You are basically telling Anaplan to get the values that correspond to Override whenever the boolean is true, but you want Anaplan to give those values for Override - which basically are non existant yet.
The idea of the override is to be used as a manual element (no formula required). Hence, the user can go there and populate it as required, leaving the if statement only in the final forecast.
The formula should be applied in Final forecast, but not in Override Forecast.
Have you removed the formula from Override Forecast?
If you go to the blueprint to the far right under "Referenced by" is that empty for Final Forecast?
The idea of the override is to allow the end user to interact with the data and manually override the time where the data may misalign with the expectation. As such, nor the boolean or the numerical override should be formula driven as defined above.
Is this your baseline forecast?
Applied the formula you said in final forecast now it is showing data like this is it correct
That seems accurate.
Happy to have helped!
now i cannot enter the value as mentioned in the image