Min/Max Functions

Version:
2019.3
Last modified: October 29, 2019

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(x, min, max): If (x < min) return min; else if (x > max) return max; else return x

Example

Bound(6,1,5) returns 5

Bound(3,1,5) returns 3

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

Example

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

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(v0, v1,..., vn): Returns the minimum value from the list.

Example

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

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?

Need something else? Visit the Alteryx Community or contact support.