Linear regression for 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

Thanks

Thiru

[jonathandienst]

Your requirement is not clear. I suggest that you post a sample qvw to help to show what you have and then explain clearly what you would like to do with this variable.

[#3]

Please click the below link,beacuse i am not able to add my sample qvw here

foercast using linear function

Thiru