Aggregates / min

min(dataset, column OR number, number...)

Finds and returns the minimum value in the given column of the given dataset, or the min value in a series of numbers specified as arguments. When looking up the min in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored. If there are no rows in the dataset, zero is returned.

For example, suppose you had a table with this dataset in it:

min({Root Container.Table.data}, 1)

... would return 120

You can also use this function to find the minimum in fixed series of numbers, specified as arguments, like this:

min(0, 10/2, 3.14)

... would return 0.

The following example is a great way to make sure a value never goes above 180:

min({SomeValue}, 180}