Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.2.2
  3. Part 2: Version 10.2.1
  4. Part 3: Version 10.2
  5. Part 4: Version 10.1.1
  6. Part 5: Version 10.1

MAX and MIN Functions

MAX and MIN Functions

Effective in version 10.2.2, the behavior of the MAX and MIN aggregation functions is changed. To maintain the behavior of the MAX and MIN functions provided in version 10.2.1 or earlier in a worksheet, rename the functions to MAXINLIST and MININLIST in the worksheet recipe.
The following table describes the functions provided in version 10.2.2:
Function
Description
MAX (value)
Returns the maximum value among all rows in the worksheet, based on the columns included in the specified expression.
MIN (value)
Returns the minimum value among all rows in the worksheet, based on the columns included in the specified expression.
MAXINLIST (value, [value],...)
Returns the largest number or latest date in the specified list of expressions.
MININLIST (value, [value],...)
Returns the smallest number or earliest date in the specified list of expressions.


Updated July 27, 2020