community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Keeping default values every month

Highlighted
Meteor

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.

 

 

 

Nebula

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

Alteryx Partner

Hi @Begnuser123,

 

 

Attached solution might help!

Maybe you can try it?


Best,
Yalmar

Meteor

Hi @Yalmar 

 

thanks! that helped

Labels