NARY_MIN
is similar to MIN
, except it allows you to compare multiple values.
Syntax
NARY_MIN(X, Y, [,Z]*)
Parameters
X, Y, Z
- fields or expressions to be evaluated.
Examples
Example 1
This example shows how you can mix fields, calculations, and literals in an NARY_MIN
function:
NARY_MIN(REVENUE, (COST * 2), 10, SESSIONS))
Example 2
Suppose you want to determine the minimum sales for your 3 sales regions by date and your data looks like this:
Date | Region 1 Sales | Region 2 Sales | Region 3 Sales |
Date 1 | 100 | 200 | 150 |
Date 2 | 75 | 130 | 150 |
Date 3 | 225 | 185 | 230 |
You could use the NARY_MIN
function to determine the minimum sales for a given date:
Example formula | Date | Output |
---|---|---|
NARY_MIN(Region 1 Sales, Region 2 Sales, Region 3 Sales,) |
Date 1 | 100 |
Date 2 | 75 | |
Date 3 | 185 |
Notes
NARY_MIN
requires at least 2 arguments. At least one argument must be a field or an expression containing a field.
NARY_MIN
works on numeric fields or expressions only. If you apply this function to other data types, you'll get an error.