AnsweredAssumed Answered

Summary Calculations

Question asked by bbqchick on Mar 16, 2010
Latest reply on Mar 17, 2010 by philmodjunk


Summary Calculations


I have a table called Loan Master which contains a balance for a loan, loan officer and number of days past due among other detail. I am selecting records for a past due report GT 30 days and calculate a total amount by loan officer for past due loan balances. So far know how to do this. I also want to calculate a total for all loans for the officer (current and past due) so I can calculate the total portfolio for the loan officer and compute the % of past dues for the officer to their total portfolio. I know how to do this in Access but having trouble thinking through how to set up in FM. Any ideas? Thanks