Growth Trend

tamerj1 @tamerI have 18 months data being loaded every month with the term Monthload. Each month load contains prior months actual and current & future months forecast values.

I have to obtain the growth trend.

Ex: CurrYear = 2022, MonthLoad = 5

Forecast(May to Dec, Jan_1 to June_1), Actuals(Jan to April)

Growth = Forecast(May to Oct i.e: 6 months) - Actuals(April) //Decides top growing & degrowing

Growth Trend = {Forecast(May) - Actual(April), Forecast(June) - Forecast(May), Forecast(July) - Forecast(June), Forecast(Aug) - Forecast(July), Forecast(Sept) - Forecast(Aug), Forecast(Oct) - Forecast(Sept)}

Trend = Forecast(May to Oct)

Forecast_May = Calculate(avg(ftes),year=2021,month_load=5, month=5)
Actual_April = Calculate(avg(ftes),year=2021,month_load=5,month=4)