Forecasting data

[#1]

Hi

i have scenario,i want to show forecasting data for another 20 years

so my dates are 2005 to 2035

sales growth rate is from 2005 to 2016 available. want to show from 2016 it need to change based on sales growth rate variable

My expression is

=if([Fiscal Year]<=2016,AVG(Sales),linest_m(total aggr(if(avg(Sales),avg(Sales),[Fiscal Year]),[Fiscal Year])*[Fiscal Year]

+linest_b(total aggr(if(avg(Sales),avg(Sales)),[Fiscal Year]),[Fiscal Year])

Please suggest me if variable name is  'sales growth rate' then where i need to put this  in the above formula.

Please find the attached document for reference.

foercast using linear function

Thiru

[#2]

Hi,

Attached is an amortization model which could perhaps be "panel-beated" to fit your requirement.

Good Luck,

Pravesh