Computes the maximum of all numeric values found in input array. Input can be an array literal, a column of arrays, or a function returning an array. Input values must be of Integer or Decimal type.

When this function is invoked, all of the values in the input array are passed to the corresponding columnar function. Some restrictions may apply. See MAX Function.

Literal example:

listmax([0,0,2,4,6,8,10,12,14,16,18,20])

Output: Returns the maximum of all values in the literal array: 20.

Column example:

listmax(myArray)

Output: Generates an output column containing the maximum of all values in the arrays of the myArray column.

listmax(array_ref)


ArgumentRequired?Data TypeDescription
array_refYArrayArray literal, reference to column containing arrays, or function returning an array

array_ref

Reference to an array can be an array literal, function returning an array, or a single column containing arrays.

Required?Data TypeExample Value
Yes

Array

myArray

Example - Math functions for lists (arrays)