Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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)