Total Sum from child table

AppSheet AppSheet Q&A
1

Hello,

I have two tables:

Productions (Parent Table)

Checks (Child Table)

Inside the Productions table, I have a column “Total Pits”, and I want to get the total sum from the Checks table under the column “Pits”. Will someone help me?

Thanks, Lon

2 
SUM(Checks[Pits])

If instead what you need for each Productions row is the sum of only that row’s Checks rows, try the following:

SUM([Related Checks][Pits])
1 Like
3

Thanks for your reply. It does work, though.

But I noticed that if add a new row in the child table, the column “Total Pits” in the parent table does not update automatically.

4

A row’s data source columns recalculate only if the row is edited–not when other rows in the same or other tables are edited. If you used a data source column for your sum, try using instead a virtual column.

1 Like
5

Thank you!

1 Like