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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Keeping default values every month

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
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