Keeping default values every month

[Begnuser123]

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.

[danilang]

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

[yalmar_m · Accepted solution]

Hi @Begnuser123,

Attached solution might help!

Maybe you can try it?

Best,
Yalmar

[Begnuser123]

Hi @yalmar_m 

thanks! that helped