Circular References and 5 year Forecast
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?