NARY_MAX

NARY_MAX is similar to MAX, except that it lets you compare multiple values.

Sample usage

NARY_MAX(Event_1, Event_2, Event_3)

Syntax

NARY_MAX(X, Y, [,Z]*)

Parameters

  • X, Y, Z - fields or expressions to be evaluated.

Example 1

This example shows how you can mix fields, calculations, and literals in an NARY_MAX function:

NARY_MAX(REVENUE, (COST * 2), 10, SESSIONS))

Example 2

Suppose you want to determine the maximum sales for your 3 sales regions by date and that 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_MAX function to determine the maximum sales for a given date:

Example formula Date Output
NARY_MAX(Region 1 Sales, Region 2 Sales, Region 3 Sales,) Date 1 200
Date 2 150
Date 3 230

Notes

NARY_MAX requires at least 2 arguments. At least one argument must be a field or an expression containing a field.

NARY_MAX works on numeric fields or expressions only. If you apply this function to other data types, you'll get an error.