Help

Summing From Tables

Topic Labels: Formulas
919 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Zachart_Gutzwil
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1
AlliAlosa
10 - Mercury
10 - Mercury

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!