5 Replies Latest reply on Dec 3, 2013 3:06 PM by erolst

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

    slayden@msn.com

      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.