1 Reply Latest reply on Mar 4, 2012 2:15 PM by davidanders

    Running totals

    RobinNeeves_2

      Title

      Running totals

      Post

      Can you please help me, I am trying to create a running total field calculating time, I have created two fields, field 1 Time travel & field 2 Time on site I want to create a third field showing the total adding Field 1 & field 2 as shown below

      Field 1Field 2Field 3 running total

      1:300:30= 2:00

      0:300:30= 3:00

      2:000:30= 5:30

      3:301:30= 10:30 and so on

      Thank you for your help

        • 1. Re: Running totals
          davidanders

          Field 1 (time)
          Field 2 (time)
          Field 3 (calculation - add Field 1 + Field 2 - result time)
          Field3RunSum (Summary Field - running total of Field 3 - result time)

          Field 1   Field 2     Field 3      Field 4 running total of Field 3

          1:30      0:30  =    2:00           2:00

          0:30      0:30  =    1:00           3:00

          2:00      0:30  =    2:30           5:30

          3:30      1:30  =    5:00          10:30

           

          Google "filemaker running summary"
          https://www.google.com/search?q=filemaker+running+summary

          Defining summary fields
          http://www.filemaker.com/11help/html/create_db.8.16.html

          Total of
          Running total
          Show the cumulative total for the current and all previous records. To restart the running total for each sorted group, also select Restart summary for each sorted group and select the field upon which the sort will be restarted from the field list.