### Title

Calculating Totals Between Related Tables

### Post

Hi everyone,

I'm trying to use the 'aggregate' function to add values from related tables, but the calculation does not seem to work. The values I am trying to add come from three separate tables, and this is what the calculation looks like from the Current Table...

EveCredSum = Sum ( Evening_Checklists::EveningCredTotal ; Morning_Checklists::MorningCredTotal ; Afternoon_Checklists::AfternoonCredTotal )

Also, is there a way that, when one record is created it can be automatically copied into another table? Without using the portals?

Best,

Winslow

Assuming that each of these "CheckLists" relationships link to multiple records en the "total" fields are number or calculation fields, use:

Sum ( Evening_Checklists::EveningCredTotal ) + Sum ( Morning_Checklists::MorningCredTotal ) + Sum ( Afternoon_Checklists::AfternoonCredTotal )