Error in formula for override forecast and final forecast

Brj73

 

BrunoRodriguez

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:

 

1. Go to the right hand side of the blueprint and check what line items are affected by both Override forecast and final forecast. 
2. You will likely find out that when changing the formula something else is happening.

 

Alternatively, please share both formulas with us and we could assess further.

 

Hope that helped!

Brj73

 

 

I am applying this formula in both the line item where i get circular reference error

 

 

BrunoRodriguez

Hello @Brj73 ,

 

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. 

 

Hope that helped!

Brj73

Earlier i used same formula that time there was no error but i deleted the dem03 module because of some error then again made dem03 module now it is showing circular refernce

BrunoRodriguez

Hello @Brj73 ,

 

The formula should be applied in Final forecast, but not in Override Forecast.

Brj73

So why it is showing circular refrence error and how to rectify it

BrunoRodriguez

Have you removed the formula from Override Forecast?

Brj73

Yes

Brj73

How to remove if it is not there

BrunoRodriguez

If you go to the blueprint to the far right under "Referenced by" is that empty for Final Forecast?

Brj73

Yes it is empty

ankit_cheeni

Hi @Brj73 

 

1. In your module, you have already calculated Initial Demand Forecast. The intent then is to get the end user the chance to override it.
2. Your 'Override?' line item allows them to check a boolean when they want to add an override right? So this should not be formula driven
3. 'Override Forecast' is where they will add the override number - so not formula driven, just a user input
4. 'Final Demand Forecast' - If your override isn't checked, it should pick up Initial Demand Forecast else you pick Override forecast. So your formula should be something like - 'IF NOT Override? THEN Initial Demand Forecast ELSE Override Forecast'

Brj73

Your are saying that formula is not required for override forecast but when i was viewing lesson 2 sprint 2 video there was formula for override forecast line item

BrunoRodriguez

Hello @Brj73 ,

 

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.

 

 

Brj73

So what will be the Correct formula .please help me i am not getting

Brj73

I applied the same formula for final forcast even then there is circular reference error

BrunoRodriguez

Hello @Brj73 ,

 

Is this your baseline forecast?

 

• IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE LAG(Default Forecast, 52, 0, STRICT)

 

Brj73

 

Applied the formula you said in final forecast now it is showing data like this is it correct

Brj73

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Default Forecast, 52, 0,)
I USED THIS FORMULA

BrunoRodriguez

Hello @Brj73 ,

 

That seems accurate.

 

Happy to have helped!

Brj73

 

now i cannot enter the value as mentioned in the image