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. |