AnsweredAssumed Answered

"Running total" field

Question asked by HankBrice on Mar 14, 2012
Latest reply on Mar 14, 2012 by 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!

Outcomes