10 Replies Latest reply on Oct 23, 2015 8:52 AM by dnechytailo

    Very simple subtotals

    dnechytailo

      Hello everyone.

       

      I am new to FM Pro, so I bring my apologies if my question turns out simple and stupid...

       

      Table 1: Companies:

       

      Comp_Code

      ...

       

      Table 2: Loans:

       

      Comp_Code

      Loan_ID

      Amount

      Currency

      ...

       

      Table 3: Currencies

       

      Curr_Code

      ...

       

      I have a portal showing all loans per company based on Loans table (related to Companies through Comp_Code field):

       

      Comp_Code          Loan_ID          Amount          Currency

      AAA                       1                     100000           USD

      AAA                       2                     50000             USD

      AAA                       3                     200000           EUR

      AAA                       4                     60000             EUR

      AAA                       5                     300000           GBP

      AAA                       6                     70000             GBP

       

      All I want is to show subtotals of loans per Company by currencies in the bottom of the same layout (portal):

       

      Total loans USD: 150000

      Total loans EUR: 260000

      Total loans GBP: 370000

       

      I've played with calc fields and summary fields in multiple ways, but didn't get any good result.

       

      I know it must be simple, but I am old Access user, which does not know all FM tricks so far

       

      Rely on your help...

       

      Thank you!