Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Aggregate Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)