AnsweredAssumed Answered

Calculating Totals Between Related Tables

Question asked by wrobinson on Feb 25, 2013
Latest reply on Mar 7, 2013 by philmodjunk

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

Outcomes