min

Description

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.

Syntax

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

Examples

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

ProductCode

Quantity

Weight

BAN_002

380

3.243

BAN_010

120

9.928

APL_000

125

1.287

FWL_220

322

7.889

 min({Root Container.Table.data}, 1) //... would return 120
 min(0, 10/2, 3.14) //... would return 0
 min({SomeValue}, 180} //This example is a great way to make sure a value never goes above 180