Using a sum of a column in a formula

Question

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.

PRP.yxmd

MarqueeCrew · Accepted Answer

@ahsankhalid ,

Almost as you wrote it:

* SUMMARIZE and get the SUM_SCP value
* APPEND FIELDS to put the SUM_SCP onto your data
* FORMULA to calculate the new column

I don't know about dividing by zero however.

Cheers,

Mark

Kenda · Accepted Answer

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!