2 Replies Latest reply on Mar 14, 2012 2:21 PM by HankBrice

    "Running total" field

    HankBrice

      Title

      "Running total" field

      Post

      Hi everyone -

      Do you know how i'd make a field which shows a calculated running total of a certain field in all records up to that point.

      Here's the application:

      I have a "tasks" database, and a few of the fields are the task to be performed, the priority from 1 to 5, and how long in minutes i expect that task to take.

      When I sort by priority, i'd like to have an additional field that shows how long all the tasks up to that point would take.  So it would look like this:

       

      Task         Priority       Time          Running total

      Do...A        High         10 min         10 min

      Do...B        High         15 min         25 min

      Do...C       Medium     30 min         65 min

       

      ...etc.

       

      Can that sort of thing be done?

       

      Thanks!