Multi Field Iterative Macro

[JTCairns]

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
First Department	1000	0.011	0.01	1022

[BenMoss · Accepted solution]

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

[JTCairns]

@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!!!

[JTCairns]

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

[BenMoss]

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