jillseurre
Technical User
I want to be able to calculate some numbers based on a forecast average and actuals.
So for example I know the average forecast for calendar year 2004 will be 1.17.
Then on month 1 I get an actual number say 1.24, I then want to be able to put a forecast for the next 11 months to achive a 1.17 average.
Then on month 2 I get and actual number say 1.09.
So MTH1 = 1.17 MTH2 = 1.09 now calculate the forecast average for the next 10mths to achive 1.17
Then on month 3 I get and actual number say 1.35.
So MTH1 = 1.17 MTH2 = 1.09 MTH3 = 1.35 now calculate the forecast average for the next 9mths to achive 1.17
I would like to have this automatically updated
any ideas
So for example I know the average forecast for calendar year 2004 will be 1.17.
Then on month 1 I get an actual number say 1.24, I then want to be able to put a forecast for the next 11 months to achive a 1.17 average.
Then on month 2 I get and actual number say 1.09.
So MTH1 = 1.17 MTH2 = 1.09 now calculate the forecast average for the next 10mths to achive 1.17
Then on month 3 I get and actual number say 1.35.
So MTH1 = 1.17 MTH2 = 1.09 MTH3 = 1.35 now calculate the forecast average for the next 9mths to achive 1.17
I would like to have this automatically updated
any ideas