Goal Seek in Excel, Iterative Macro

[YLYONG]

Hi Alteryx Community,

I have simple workflow which I need help with on how to achieve the same outcome same as "Goal Seek" in Excel:

Change utilisation rate to match targeted utilisation rate of 85

By changing days cover

Thank you for your help!

[YLYONG]

Hi Alteryx Community,

Plase can I get your help on this? 

Thank you

[apathetichell]

check out the optimization tool. honestly the reason why you aren't getting any bites is that this isn't simple and getting syntax down for the optimization tool can be difficult.