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

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.

Example Goal Seek with Value Floor.xlsx

Macros

Dynamic Processing

Iterative Macro

Behavior Analysis

Accepted answers

Hey @JCA

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

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

GoalSeeker.yxzp

All comments

Hey @JCA

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

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

GoalSeeker.yxzp

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?

Can I get the workflow to solve this goal seek in Alteryx?

@cakivibesHey - I'd recommend looking into some of the other solutions to this kind of issue - posting in a five year old thread looking for a solution won't help you out. FWITW I'd explore using running total to create discounted cashflows - and then look into the gap between where you are and where you need to be for the final value. Reminder though - we're all volunteers so "can I get a workflow" might not get you where you need to be. I don't build workflows on spec like this - and this community is really about helping people who are troubleshooting problems in their workflow builds vs building ad hoc solutions.

Quick Links

Tags

Workflow
Output
Preparation
Datasets
Input
Developer
Help
Tips and Tricks
Common Use Cases
Server
Transformation
Developer Tools
Macros
Data Investigation
Best Practices

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703