max

Description

Finds and returns the maximum value in the given column of the given dataset, or the max value in a series of numbers specified as arguments. When looking up the max 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
max( 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

max({Root Container.Table.data}, 1) //would return 380
max(0, 10/2, 3.14) //would return 5. You can also use this function to find the maximum in fixed series of numbers, specified as arguments
max({SomeValue}, 0) //The following example is a great way to make sure a value never goes below zero: