Yes it is on list view as you can see n my example where it shows the 3 records. I changed to form view just for the heck of it, but that isn't right
and that part of the Layout is set to Grand Total Summary ?
On the last line (Grand Total balance), you should have the same field as for each record Current Balance.
Is the ::Total_Principle field a calculation field ?
1 of 1 people found this helpful
If total_principle is the summary field that you are talking about, it's from the wrong table occurrence. The leading :: shown indicate that it's from a related TO, not the TO on which your layout is based.
In such case, you get a summary value based on the set of related records, which in this case could be just one record, the one linked to the last record in your found set. That would fit what you describe here anyway.
In Order for a summary field to show a grand total based on all records in your found set, it must both be defined in that same table as that on which your layout is based and also from the same occurrence of that table.
That sounds right. The problem is the loan page has a record for each payment, so If I run it in the example above based on the Vehicle_Loan I now get more than 3 records, as some are multiple entries for the same loan.
Is there a way to return just one record per loan in that table?
Use a sub-summart part instead of a body part and sort by loan page id.
Thanks for the idea. In trying that I do the the records on screen to just show one of each, but the total has the duplicate record total
So if I had 2 payments on a loan and the balance on that loan is 3,000 the total shows 6,000.
Let's get a clearer picture of your data model and your layout context.
Let's say three payments are made on a given loan. How are those three payments recorded? Will you use 3 records in the Vehicle_Loan table?
If so, the summary field computing the total payments would be defined in Vehicle_Loan. Alternatively, a calculation field in Vehicles can total the payments by using Sum ( Vehicle_Loan::Payment) to compute the total payments.
Thanks for the reply.
Yes, if 3 payments are made, there are 3 entries in the Vehicle_Loan Table.
As part of that record a calculation is made of the remaining balance, all 3 of the records have the same remaining balance in a field "balanceDue"
That is the field I want to total, but I don't want to count it 3 times, just once per loan.
If you count it once per loan, you aren't totaling it. Is this a loan arrangement such that the balance due might be different on different records for the same loan? If so, which do you need, that of the most recent payment? If it's exactly the same each time, you don't need to put it in the Vehicle_Loan table, you can keep it in the loan table.
The Vehicle_Loan Table is the Loan table
In your original post, you describe 3 tables:
Loan and Vehicles the Joined Table is Vehicle_LOANS
That does not match what you have just posted.
A table with one record for each Loan is the table that I am referring to and is not the Vehicle_Loan join table used to record each loan payment in a different record.