Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have scenario,i need to show forecast data.
I am using linest_m and Linest_b functions and able to generate the forecasting piece
=if(Year<=2016,AVG(SalesGrowthRate),(linest_m(total aggr(if(avg(SalesGrowthRate)+$(Sales Annual Growth Rate),avg(SalesGrowthRate)+$(Sales Annual Growth Rate)),Year),Year)*Year
+linest_b(total aggr(if(avg(SalesGrowthRate)+$(Sales Annual Growth Rate),avg(SalesGrowthRate)+$(Sales Annual Growth Rate)),Year),Year)))
But my scenario is the forecasting data is
after 2016 i want show SalesGrowthRate=SalesGrowthRate+(SalesGrowthRate*($(Sales Annual Growth Rate)))
Can any body send the syntax using lineest_m and linest_b for getting the above logic
Please find the attached excel and qvw for reference
Thanks and Regards
Thiru