Summing From Tables

Hi, I have a database set up with multiple tables.
Set up like this
Person1 (Information in one table) gets 5 Linked Entries in another table
How can I get these linked records to sum in the table with the first table

Hi there!

Not sure what you’re trying to sum up, but…

If you only want to count how many linked records there are for a particular person, you can use the Count field type. Otherwise, you’ll likely want to use a Rollup field.

Add a field on the first table, point it at the field on the second table that you want to sum up, then use the formula:

SUM(values)

Hope that helps!

1 Like