MAX Function

Returns the maximum value of a series of values.

Category: Mathematical
Returned data type: Real

Syntax

MAX(argument1 <, argument2, …>)

Required Argument

argument1

specifies a value that has a real data type; this can be specified as a numeric constant, field name, or expression

Optional Argument

argument2, ...

specifies one or more values that have a real data type; these can be specified as a numeric constant, field name, or expression

Details

The function returns null if all values are null.

Example

x = max(1, 3, -2)

// outputs 3

 

x = max(1, null, 3)

// outputs 3

 

x = max(-3)

// outputs -3

 

x = max(4, -3*1.5)

// outputs 4