Hey all,
I've been trying to find the easiest way to create a new field comprised of the difference of two current fields for 19 different fields in my workflow at the same time (without using the formula tool like crazy) and am struggling to find a simple workflow that works in the forums. I'm fairly certain the multi-field formula tool doesn't work for this, from what I've read, due to not being able to select the field next to the current field as part of the formula (that would've made it much easier). I've included a screenshot below, if having the workflow would help let me know and I'll create a version that I'm allowed to share. Any advice is appreciated!
Solved! Go to Solution.
Hello @BSmithdubz,
My first thought was a formula tool and create all the combinations (but that would take time on the first set up and then the rest would be tough), so my next thought is creating a batch macro that would loop through column headers as groups, create the difference column and then output that difference column back out with the data. If you attached a sample of the data, I could work through my thought for a macro.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |