Nota
Capaian ke halaman ini memerlukan kebenaran. Anda boleh cuba mendaftar masuk atau menukar direktori.
Capaian ke halaman ini memerlukan kebenaran. Anda boleh cuba menukar direktori.
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)