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

    Grand Summary not showing total


      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?