MAX and MIN: Finding the Maximum or Minimum Value
Available Languages: reporting, Maintain
The MAX and MIN functions return the maximum or minimum value, respectively, from a list of values.
Find the Maximum or Minimum Value
{MAX|MIN}(value1, value2, ...)
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, the name of a field that contains the values, or an expression that returns the values. If you supply an expression, use parentheses as needed to ensure the correct order of evaluation.
Note: MAX
and MIN do not use an output argument. The format of the result is
floating-point double precision.
Determining the Minimum Value
MIN returns either the value of ED_HRS or the constant 30, whichever is lower.
MIN(ED_HRS, 30)
For 45.00, the result is 30.00.
For 25.00, the result is 25.00.
MIN returns either the value of the ED_HRS field or the constant 30, whichever is lower:
TABLE FILE EMPLOYEE PRINT ED_HRS AND COMPUTE MIN_EDHRS_30/D12.2 = MIN(ED_HRS, 30);BY LAST_NAME BY FIRST_NAME WHERE DEPARTMENT EQ 'MIS'; END
The output is:
LAST_NAME FIRST_NAME ED_HRS MIN_EDHRS_30 --------- ---------- ------ ------------ BLACKWOOD ROSEMARIE 75.00 30.00 CROSS BARBARA 45.00 30.00 GREENSPAN MARY 25.00 25.00 JONES DIANE 50.00 30.00 MCCOY JOHN .00 .00 SMITH MARY 36.00 30.00