Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

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

4 REPLIES 4
LordNeilLord
15 - Aurora

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

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

 

 

LordNeilLord
15 - Aurora

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

lauren_collins
5 - Atom

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

or @LordNeilLord

Labels