1 Reply Latest reply on Mar 20, 2010 3:29 PM by davidanders

    Still Having Trouble With PerCent To Total of Self Join Table

    bbqchick

      Title

      Still Having Trouble With PerCent To Total of Self Join Table

      Post

      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. 

       

      Thanks

        • 1. Re: Still Having Trouble With PerCent To Total of Self Join Table
          davidanders

          I apologize, it may be the weekend.

          Could you simplify the explanation?

          Table One  "Guys"

               Guy                     Name                        Text Field

                Loans                LoadID                      Number Field

                LoansBad        LoanStatus               Checkbox

          Relates to Table Two with NameID to LoanNameID

          Table Two  "Loans"

               Guy                     Name                        Text Field

                Loans                LoadID                      Number Field

                LoansBad        LoanStatus               Checkbox

          As sort of a bad inaccurate example