14 Replies Latest reply on Nov 12, 2016 10:49 AM by philmodjunk

    Grand Summary not showing total

    Tom_Droz

      Windows FM14A

       

      I have 2 tables, Loan and Vehicles the Joined Table is Vehicle_LOANS

       

      I have a report based on the layout Vehicles  That shows the total AmountDue (Calculation: Original_Loan_Amount - Vehicles_Loan_PAYMENTS::Total Principal Payments)

       

      I then have a TotalAmountDue which is a summary of Total of AmountDue

       

      When I place the summary field in the Grand Summary section it only gives a value equal to the last record, rather than a total.

       

      What am I missing?