Min/Max Functions

Version:
Current
Last modified: June 26, 2020

A minimum or maximum function finds the smallest and largest value of a set of values. Min/Max functions can only be used with Number data types.

Bound

Bound(x, min, max): If (x < min) returns min, else if (x > max) return max, else returns (x).

Example

Bound(6,1,5) returns 5.

Bound(3,1,5) returns 3.

Max

Max(v0, v1, ..., vn): Returns the maximum value from the list.

Example

Max(15, 180, 7, 13, 45, 2, 13) returns 180.

MaxIDX

MaxIDX(v0, v1,..., vn): Returns the 0-based index of the maximum value from the list.

Example

MaxIDX(15,180,7,13,45,2,13) returns 1.

Min

Min(v0, v1,..., vn): Returns the minimum value from the list.

Example

Min(15, 180, 7, 13, 45, 2, 13) returns 2.

MinIDX

MinIDX(v0, v1,..., vn): Returns the 0-based index of the minimum value from the list.

Example

MinIDX(15, 180, 7, 13, 45, 2, 13) returns 5.

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.