AnsweredAssumed Answered

"Running total" field

Question asked by HankBrice on Mar 14, 2012
Latest reply on Mar 14, 2012 by HankBrice


"Running total" field


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




Can that sort of thing be done?