Circular References and 5 year Forecast

Options
LaurieW
LaurieW Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi,

 

Circular References and 5 year Forecast.

 

I am trying to use the Prior Year's final forecast as the starting point for the new year and get circular references because of the calculations in between.

I am using the Previous year's Actuals as the starting point which is fine as this line does not relate to the calculation.

I am using a summary module by year and a detailed module by month.

I'm sure this has been done many times before so I am hoping someone has a simple workaround for me?

 

Thank you

Laurie

Tagged:

Comments

  • LaurieW
    LaurieW Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hi Andrew,

     

    I managed to resolve this with help from my manager.

    I was using LOOKUP on a Year or a previous year which was causing the problem.

    I had to change this to YEARVALUE. Where it was part of a formula that did other LOOKUPs I created an extra line item for the YEARVALUE and then used that line item.

     

    I was using LAG in another line item and it is really great but that wasn't where my problem was.

     

    Much appreciated 

    Thanks

     

     

  • LaurieW
    LaurieW Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Thank you very much. Please see my reply above.

Categories