Hi All,
I am creating a workflow, where i am gettting data for the previous month in the current month and i need to forecast.
Example
MonthYear Sales Forecast
Oct-2018 334
Nov-2018 555
Dec-2018 111
Jan-2019 222 123
Feb-2019 (0.5*222)
Mar-2019 (0.7*222)
I need to change this every month whenver i get data for the earlier month. Is there a way to bring it in a formula that it adjusts itself whenever a new sales input is provided.
Solved! Go to Solution.
hi @Begnuser123
Where do you get the multipliers(0.5, 0.7, etc) from? Do you always forecast for the next 2 months only?
Dan