Help & Support
Display Legacy Contents


Home > Impact Suite > Math > Summing Up Child Tables

Summing Up Child Tables

Let's take summing up to another level. Let's say you create a sub-sub table called "Auto Expenses" that is a child of your "Automobile" table. (See Designing Sub Tables for more on designing sub tables.) Imagine you would like to sum all the expenses for each Automobile and also sum ALL expenses for ALL Automobiles up to the Contact record. This can be easily accomplished by following the steps on Summing Up Parent Table

In this diagram we modified two columns to complete the overall function

  1. The AMOUNT column in the Automobile Expense table is summed up to "Expense Total" field in the Automobile table.
  2. Then the EXPENSE TOTAL column from the Automobile table is summed up to the "Expense(s) Total" field in the Contact table.

See also

Article ID:
Views: 218
Created By: jimdurkin
Modified By: [Modified By]
Created Date: 3/24/2014 12:31 PM
Last Modified: 3/24/2014 1:47 PM
Print This Article
Email This Article
Previous Article
Next Article