Hi Community,
I am trying to use the sum of a column to create a new column in a workflow. Please can you share some ideas.
e.g. for record ID 1, the calclulation for the new column will be 35*(192/0).
this is test data and the real one will have very less 0s.
Solved! Go to Solution.
Almost as you wrote it:
I don't know about dividing by zero however.
Cheers,
Mark
Hey @ahsankhalid!
The key here would be to use a Summarize tool to sum your SCP field then use an Append Fields tool to add that totals column back to each record from your input. From there, just use your new totals field in your calculation to create your new field.
Hope this helps!
Great! Exactly what I was searching for. I didn't realize that I needed to use the Append tool. I would still prefer to have simple functions like count distinct and sum built into the formula tool.
User | Count |
---|---|
19 | |
15 | |
15 | |
9 | |
8 |