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?