min(X;Y)

Returns the smaller of two given values.

Syntax

min(X;Y)

Input

Argument Type Description
X any numeric type The value to compare to Y
Y any numeric type The value to compare to X

Return Value

Returns a numeric value corresponding to the smaller value of X and Y.

If both X and Y are integers, the result is an integer; otherwise, the result is a decimal number.

If X and/or Y is N/A, the result is N/A.

Sample Usage

X Y min(X;Y)
2 1 1 (integer)
2 3 2 (integer)
1.5 1 1 (decimal)
1.5 2.5 1.5 (decimal)
1.5 1.2 1.2 (decimal)
NA 1 NA (integer)
1.0 NA NA (decimal)

Example

In this example, the min(X;Y) function returns the minimum value between the runs and hits using the columns r and h respectively from pub.demo.baseball.postbatting.

<base table="pub.demo.baseball.postbatting"/>
<willbe name="min" value="min(r;h)" label="Minimum"/>
<colord cols="r,h,min"/>