Forecasting data

Wed, 25 Nov 2020 16:16:04 GMT

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.

Thiru

Re: Forecasting data

Mon, 13 Jun 2016 09:02:37 GMT

Hi,

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

Good Luck,

Pravesh