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)

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

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

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

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

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.