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

    Combining Record values

    JeremyBiesecker

      Title

      Combining Record values

      Post

           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?

      Capture2.PNG

        • 1. Re: Combining Record values
          JimMac

               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:
               1.
               With the database open, choose File menu > Manage > Database.
               2.
               In the Manage Database dialog box, click the Fields tab.
               3.
               If your database contains more than one table, select the appropriate table from the Table list.
               4.
               For Field Name, type a name for the field.
               See About naming fields.
               5.
               For Type, select Summary.
               6.
               Click Create.
                
                
               JIm...
          • 2. Re: Combining Record values
            philmodjunk

                 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
              JeremyBiesecker

                   Thanks, this pretty much solved the problem.