AnsweredAssumed Answered

Trailing Grand Summary not calculating

Question asked by BryanN on Mar 29, 2013
Latest reply on Mar 29, 2013 by BryanN

Title

Trailing Grand Summary not calculating

Post

     My report is based on the Jobs table, and each job can have multiple related records in the JobLineItems table (these are entered via a portal).  I created a summary field that summarizes all of the line items in each job (a line item has a qty X $price).  The summary field seems to be caculating fine on a per job basis from what I can see, as it's correctly calculating the sum of all the line items for each job.

      

     However, if I switch to the report layout, based on the same Jobs table, the trailing grand summary shows values from the last record in my find, not a grand total.  The grand total field is the same summary field used to total each job, and it's in a part defined as a trailing grand summary.  Help!

      

      

Screen_Shot_2013-03-29_at_1.34.01_PM.png

Outcomes