I have a file of three tables:
I am building a report from Trans_People_Join where I need to summarize (total) a field (loanAmount) of the found set.
- search fields for found set are personID and CloseDate
- The summary field I am using is TotalFunded from Transaction, which totals LoanAmount
- I am using list mode and putting the TotalFunded field in the footer, but U only get the active record's LoanAmount. How do I get the total of the found set?
Thank you for any advice.