MAX (Report Builder)
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)