You should have a field for loan amount such as "LoanAmount". You can create calculations fields based on loan amount such as:
LoanUnder100: If ( LoanAmount < 100 ; LoanAmount )
Loan100to200: If ( LoanAmount >= 100 and LoanAmount < 200 ; LoanAmount)
Loan200Greater: If ( LoanAmount >= 200 ; LoanAmount )
Then you create a Summary Field for each of these with running total for each of these calclulation fields. You will put the Summary fields in the sub-summary layout parts in the FileMaker layout or Trailing Grand Summary or whever you need them.
LoanUnder100Total = TOTAL of LoanUnder100 (running total)
Loan100to200Total = TOTAL of Loan100to200 (running total)
LoanGreaterThan200Total = TOTAL of Loan200Greater (running total)
Thanks for the quick reply, I'm going to try a bit later...I'll let you know how it works out.
Cool, I like whow you added the body for explanation of the total, I can see this being helpful! Thanks
You're welcome. If you're willing to define another field for numerical sorting and summarize by that value, you can use any text because you don't have to use it for proper sorting.