Applying Simple % Formula to 50+ Fields

Hi,

I am trying to apply these 3 formulas to the rest of the numeric fields in my data set. I originally thought to batch macro and cycle through these fields 3 at a time, but I'm wondering if there is another tool I am forgetting about that could be used? I also could list out all formulas one by one, but that seems inefficient as well. Thanks for the help!

Macro 2 Completion Analytic.yxzp

Workflow

Macros

Accepted answers

jdunkerley79

Sorry had misunderstood the problem. I would do something like:

- As with your macro, work out the parts

- Next, transpose the data to be row-based

- Join total on and work out the %Total

- Cross tab the data back to be column based

- Use a dynamic rename to get column names back to what they should be

- Using a union tool and keeping 1 row of the original it is possible to restore original column order

Have attached a sample

Macro 2 Completion Analytic 2.yxmc

All comments

jdunkerley79

You can use the Multi Field Formula tool to apply to all numeric fields in one go.

You would need 3 such tools but should allow you to do what you want

BSmithdubz

I'm looking to get around 50 fields as outputs (each field has to generate a % of total field). I am not sure how to reference both fields used in the formulas in the multi-field tool.