% formula for multiple records in a summation

[mckenseycatterton]

I am trying to get the % of multiple records from a summation, but when I create the formula it only gives me the calculation for one record instead of all records. How do I make the formula translate to all records? Screenshots include my current steps

[phottovy · Accepted solution]

Hi @mckenseycatterton ,

I would recommend the "Append Fields" tool instead of the "Join Multiple" tool in this case. When you select "Join by Record Position" it will only join on rows that exist in both data sources. That is why row 1 is populated and row 2 is null. With the append tool, it will add the total count to each row in your data set:

Join Multiple Result:

Append Fields Result :

[mckenseycatterton]

THANK YOU! this worked!

[phottovy]

Hi @mckenseycatterton ,  if my answer helped, please mark it as an accepted solution so others can find it in the future. Thanks!