Still Having Trouble With PerCent To Total of Self Join Table
Relatively new user to FM11 Pro.
Table 1--Loan Master. Sorted By Officer. Found Set is past due loans for loan officer. Calculates total loans of Found Set (past due loans by Officer) correctly in sub-summary report and using Get Summary function.
Table 2--Is Self Join of Loan Master joined by Officer Name. Called Loan Master_By Officer. Sorted by Officer. Found set is entire portfolio of loans for the officer--not just past due items. Calculates total loans of Found set (all loans by Officer) correctly in sub summary report. Get Summary function does not appear to work for this related file.
What I want to calculate is the percentage of past due loans by Officer to Total Loans by Officer. How do I do this in a sub summary report.