RUNNING_MIN

RUNNING_MIN(SUM([Hours Spent]))

Syntax

RUNNING_MIN({aggregation method}(numerical expression))

A running min is the minimum of a sequence of numbers which is updated each time a new number is added to the sequence.

aggregation method: Any aggregation function SUM, MAX, COUNT and etc applied to numeric expression.

numerical expression: Basic arithmetic calculation created using the math operators +, -, *, /, numerical data fields and constants.

For example we have the data set below after applying aggregation COUNT([ID]) to income record set

Applying RUNNING_MIN(COUNT([ID])) will give the table below

Shows the running minimum for tasks spent time over date.

Time tracking stats for tasks of the building super hero suit

Completed On	Task	Hours Spent	Feature
03 Jan 2018 10:13 AM	Create a steel helmet to protect head	19	Protective Suit
20 Jan 2018 04:08 PM	Create a chest protection from steel	45	Protective Suit
05 Feb 2018 11:34 AM	Ask agency to create fancy identity for new super hero	30	Design
09 Feb 2018 02:11 PM	Install super hero logo on body and helmet	2	Protective Suit
09 Feb 2018 02:11 PM	Put on gloves with nice color	2	Protective Suit
12 Feb 2018 09:01 PM	Ask Hulk to push in head	5	Combat Testing
01 Mar 2018 06:45 PM	Ask Hulk to push in chest	5	Combat Testing