Math, Add Rows Together

[luminrabbit]

I have a Players table (with Total Points)

Then I have another Results table (with Points Earned)

Im trying to take all of the points Jane Smith has earned in the Results table so far and total that number up in the Players table under Total Points (which would be 2,950 right now she has a place holder of 100).

How would go about this? Thank You!

[Jeff_Hager]

Create a relation linking the player id in the players table to the player id in the results table. Then create a Rollup column that uses the relation to get a sum of points from results. Then create a math column to add the two values together.

[luminrabbit]

Hi @Jeff_Hager,

Ive added the relation column in the Players table

Then created the rollup column in the Players table and used Sum

Unfortunately all of the rows have the same number in the Rollup output, anything else I should try?
It seems to be totaling all of the numbers and not by the player per row.

[Himaladin]

1. In the relation column, you must check match multiple.
2. In the rollup column, direct the summarize value option to the relation you created previously, not to the table directly

[luminrabbit]

Thank you very much @Himaladin
This is fantastic Ive been trying this for quite sometime and I now see where I was going wrong (I have to go through the relation to the points) absolutely amazing. Thank you so much!