maximum

Returns the maximum value of selected data items. Distinct is an alternative expression that is compatible with earlier versions of the product.

Syntax

maximum ( [ distinct ] expression [ auto ] )
maximum ( [ distinct ] expression for [ all|any ] expression { ,
 expression } )
maximum ( [ distinct ] expression for report )

Example

maximum ( Sales )

Result

Returns the maximum value out of all Sales values.