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.

yalmar_m

Hi @Begnuser123,

Attached solution might help!

Maybe you can try it?

Best,
Yalmar

Solution.yxzp