3 Replies Latest reply on Mar 28, 2013 1:54 PM by JeremyBiesecker

    Combining Record values



      Combining Record values


           I need to be able to add up the totals from each record within a certain period of time (usually per year), and display it as a total, preferably in a seperate Layout/Report in the same database. I can't figure out how to do it, does anyone know how?


        • 1. Re: Combining Record values

               Do a Find on the Date range  you want and use...


          Defining summary fields
               Use summary fields to calculate values such as subtotals, averages, and grand totals across multiple records. For example, a summary field can display the grand total of all sales in the month of May in a report.
               To define summary fields:
               With the database open, choose File menu > Manage > Database.
               In the Manage Database dialog box, click the Fields tab.
               If your database contains more than one table, select the appropriate table from the Table list.
               For Field Name, type a name for the field.
               See About naming fields.
               For Type, select Summary.
               Click Create.
          • 2. Re: Combining Record values

                 Summary fields and sub summary layout parts are designed with that purpose in mind.

                 This old, but still applicable tutorial on summary reports may be useful to you: Creating Filemaker Pro summary reports--Tutorial

                 Please use Post A Answer to post any questions about that tutorial here rather than in the tutorial thread.

            • 3. Re: Combining Record values

                   Thanks, this pretty much solved the problem.