Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Please click the below link,beacuse i am not able to add my sample qvw here
foercast using linear function
Thiru