Automated Forecasting Help?

[Kyra88]

Hi All !

I was wondering if anyone can help me reach a solution.

I would like to know if it is possible to automate forecasting data on Alteryx?

I have attached a sample excel file where I manually input a forecast growth % value for the market and company to determine the companies forecasted sales value and market share.

(The forecast values are based on a % increase from the same month in the previous year - Year on year)

Are there any tools in Alteryx where I could replicate this? As well as any tools in alteryx that are similar to Excel's 'Scenario Manager' and 'Goal Seek'? The main aim is for the model to be automated.

I have also attached my workflow so far.

All suggestions are welcome! Thank you in advance!

[Kyra88]

Hi @AngelosPachis 

I keep getting the same error message. I've used the select tool to see the data type, Value and A2 Forecast are both set to 'Double'.

I double checked the data types after the generate rows tools before the macro and all 3 are set to 'Double'. 

Again the batch macro runs fine its just the macro in the workflow where I keep getting the error message.

Could this maybe be an issue with my current version of Alteryx?

Thanks,

Kyra