CumulativeMin

The CumulativeMin function calculates the minimum value of a column up to and including the current row value.

Syntax

CumulativeMin(\[Column\])

Function Arguments:

  • [Column] (required) - The column of numbers to evaluate the cumulative minimum.

πŸ“˜

Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.

Example

CumulativeMin(\[Monthly Revenue\])

A table contains the monthly revenue for a store. The CumulativeMin function can be used to find the minimum monthly revenue up to and including the current month.



Related resources