Share via

  • Article

MAX (Report Builder 1.0)

Returns the maximum value in a set.

Syntax

MAX(aggregate)

aggregate

Specifies the field name or expression to aggregate.

Remarks

  • For text values, MAX finds the highest value in the collating sequence defined in the underlying database.

  • Null values are ignored.

Example

Formula

Result

MAX(Total Due)

The highest value is returned from a set of all Total Due values.