Alteryx designer Discussions

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

Replicating Excel "Goal Seek" to solve for aggregate by changing rate input

Highlighted
5 - Atom

I'm relatively new to using Alteryx and its ability to use iterative macros.

 

I've been trying to automate a process that is currently done by using Excel's "Goal seek" to solve for a rate.

 

As an example I've attached the fundamental logic and a simple scenario where Y = MAX([M x X] + C],A) and the Sum of all Y values needs to be 50,000.

 

I've had some success but always seem to fail at integrating the "MAX" part into the equation/macro.

Highlighted
Alteryx Certified Partner

Hey @JCA

 

How about this? It's a bit rough but it does the job.

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

5 - Atom

Hey @LordNeilLord

 

Thanks, that worked a treat, I had to split my population when the iterations maxed out at 2,000 but its been working ever since,

 

One question though, why do you multiply the multiply the threshold by 1.1?

 

 

Highlighted
Alteryx Certified Partner

Hey @JCA

 

Sorry I didn't see your original reply!

 

The 1.1 multiplication is just to make sure that I capture just over the desired value (there's probably a better way to do that)...for example I'm looking for 5000...I want to capture 5010 rather than 4800

 

Neil

Highlighted
5 - Atom

How did you solve for the maxing out at 2000 iterations?  

or @LordNeilLord

Labels