3 Replies Latest reply on May 11, 2014 3:05 PM by philmodjunk

    Dashboard Totals

    Hagar_2

      Title

      Dashboard Totals

      Post

           Hi 

           I have a three tables linked (Months to Transactions to Assets). I am however unable to display a total transaction balance per asset up to a given date in the Months table. Attached is the relationship diagram. Please help.

           Thanks

      Relationships.png

        • 1. Re: Dashboard Totals
          philmodjunk

               A global field to global field relationship won't work. gDateEntered seems the wrong field to use as a match field here.

          • 2. Re: Dashboard Totals
            Hagar_2

                 I removed link the dashboard and based on only the months table I am still unable to extract the balances per asset based on the months in a portal. It keeps on giving me the total capital amount and not just up to the date selected.

            • 3. Re: Dashboard Totals
              philmodjunk

                   So when you removed it, what relationships do you have in place now?

                   Using conventional calculation and/or summary fields to get subtotals of different records requires setting up either a relationship that matches to the specific group of records needed to compute that sub total, use a filtered one row portal with a summary field where the portal filter limits the related records to the group to be totaled or, if using FileMaker 12 or newer, you use an aggregate function inside an ExecuteSQL calculation.