max

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.

This function expects the data type of the column to be numeric: other data types, such as strings, will throw an exception.

Any null values in the column are ignored. 

max(dataset, columnIndex)

• Parameters

Dataset dataset - The dataset to search through.

Integer columnIndex - The index of the column to search through. Must be a column index of the provided dataset. Additionally, the data type of the column must be numeric.

• Returns

Integer - The maximum value in that column.

max(dataset, columnName)

• Parameters

Dataset dataset - The dataset to search through.

String columnName - The name of the column to search through. Must match a column name in the provided dataset. Additionally, the data type of the column must be numeric.

• Returns

Integer - The maximum value in that column.

max(value, [value, ...])

• Parameters

Integer/Float value - A number. Can be as many values as needed. Can be either a float or an integer.

• Returns

Integer - The maximum value in the list of values.

max(sequence)

• Parameters

Sequence sequence - A list, tuple, array, or set of numerical values. 

• Returns

Integer - The maximum value in the list of values.

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

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.