Summary field not summarizing from join table - just giving current record

Discussion created by on Dec 3, 2013
Latest reply on Dec 3, 2013 by erolst

I have a file of three tables:

  1. Transaction
  2. Trans_People_Join
  3. People

I am building a report from Trans_People_Join where I need to summarize (total) a field (loanAmount) of the found set.

  1. search fields for found set are personID and CloseDate
  2. The summary field I am using is TotalFunded from Transaction, which totals LoanAmount
  3. 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.