Reporting Language > Numeric Functions > MAX and MIN: Finding the Maximum or Minimum Value

MAX and MIN: Finding the Maximum or Minimum Value

How to:

The MAX and MIN functions return the maximum or minimum value, respectively, from a list of values.

Syntax: How to Find the Maximum or Minimum Value 

{MAX|MIN}(value1, value2, ...)

where:

MAX

Returns the maximum value.

MIN

Returns the minimum value.

value1, value2

Numeric

Are the values for which the maximum or minimum value is returned. If you supply an expression, use parentheses as needed to ensure the correct order of evaluation.

Example: Determining the Minimum Value

WebFOCUS

Feedback