cancel
Showing results for
Did you mean:

# Alteryx designer Discussions

SOLVED

## Multi Field Iterative Macro

Asteroid

Morning All,

My brain isn't working today. I need to make an App wherein 10 departments get their base budget increased by X% and/or Y% every year.

The end amount of year 1 is the start amount of year 2. I could (and have) make 9 sets of formulae but I would rather make this smart. can anyone point me in the right direction? (I'm sure I've done this before but I'm really not braining well today)

 Department Start Amount X% Y% End Amount FirstDepartment 1000 0.011 0.01 1022
Alteryx Certified Partner

I think you'd be overcomplicating this if you went down the iterative macro route; this should be possible with a multi-field formula tool.

I've attached a working example for you.

Ben

Asteroid

@BenMoss

This is great, I was basically doing this but was going wrong somewhere. I think its because the end amount is Start + (Start * X%) + (Start *Y%). I then need to calculate the difference etc. I was thinking of an iterative because this will be a forecasting/scenario App. Thanks for the help you're a proper legend!!!

Asteroid

Hi Ben,

You really helped me with a question earlier and I was wondering if you could help again.

I have to create an app to forecast budgets. I have 13 departments, across 4 years with 2 types of possible funding. This means I have 104 variables. I have created the numeric up downs for them and designed the interface but im struggling with a way to "plumb" it all in.  All variable need to be editable. Can you help?

 Group Year 1 Type A Year 1 Type B Year 2 Type A Year 2 Type B Year 3 Type A Year 3 Type B Year 4 Type A Year 4 Type B Department 1 -0.01 1.00 0.00 1.00 1.00 0.00 1.00 -1.00 Department 2 1.00 1.00 1.00 0.00 -1.00 0.00 1.00 1.00 Department 3 1.00 0.00 1.00 0.00 0.00 1.00 -1.00 1.00 Department 4 1.00 -1.00 -1.00 1.00 1.00 0.00 0.00 1.00 Department 5 0.00 -1.00 1.00 -1.00 -1.00 0.00 -1.00 1.00 Department 6 1.00 0.00 0.00 1.00 -1.00 0.00 1.00 -1.00 Department 7 1.00 -1.00 0.00 1.00 -1.00 -1.00 -1.00 1.00 Department 8 -1.00 0.00 0.00 0.00 1.00 0.00 -1.00 1.00 Department 9 1.00 1.00 0.00 0.00 -1.00 0.00 1.00 1.00 Department 10 -1.00 -1.00 0.00 1.00 0.00 -1.00 0.00 0.00 Department 11 0.00 -1.00 -1.00 -1.00 0.00 0.00 0.00 1.00 Department 12 1.00 1.00 -1.00 0.00 -1.00 -1.00 1.00 1.00 Department 13 1.00 -1.00 0.00 1.00 -1.00 1.00 1.00 1.00

Highlighted
Alteryx Certified Partner

I would do something like follows;

With each of your numeric updowns, on the confiugration pane, go to the 'Annotations' tab and name each one uniquely (with no spaces); something like DepartmentOneYearOneTypeA...

You can then reference this in a text input, or formula, using the syntax %Question.NAME%

You can also create placeholder values for these so when you are developing your workflow the placeholder values are passed in, this can be done on the workflow configuration pane...

Now when I run my workflow in developer mode, I don't get the 'text' that I have written in the text input, but instead the value given in the workflow configuration constants...

But when I run it as an app, I get my user values to pass in (Y)

Example shown in these images attached.

Ben

Labels