Statistical Functions

AVERAGE(…x : number | <expression>)

Returns the average of the numbers passed to the function. Only numbers and arrays of numbers are processed.

AVERAGEA(…x : number | <expression>)

Returns the average of the numbers passed to the function. Numbers, arrays of numbers and values representing numbers (such as true, false and string representation of numbers) are processed.

COUNT(…x: number | <expression>)

Counts the number of numeric values passed to the function. Only numbers and arrays of numbers are processed.

Example

COUNT(1,2,"test") returns 2 
COUNT(ARRAY(1,2,3)) returns 3

COUNTA(…x : number | <expression>)

Counts the number of logical values passed to the function. Numbers, arrays of numbers and values representing numbers (such as true, false and string representation of numbers) are processed.

Example

COUNTA(1,2,"3") returns 3 
COUNTA(1,2,"x") returns 3 
COUNTA(1,2,null) returns 2 
COUNTA(ARRAY(1,2,3,4,true,"")) returns 6

COUNTBLANK(…x:number | <expression>)

Counts the number of null-values passed to the function.

Example

COUNTBLANK(null) returns 1 
COUNTBLANK(ARRAY(1,null,1,null)) returns 2

MAX(…x : number | <expression>)

Returns the max value of the numeric values passed to the function. Only numbers and arrays of numbers are processed.

Example

MAX(1,4,3,true,null) returns 4 

MAXA(…x : number | <expression>

Returns the max value of the numbers or numeric representations of the values passed to the function.

Example

 MAXA(false,null) returns 0 
 MAXA(0,true) returns 1 

Other:

MIN MINA STDEV STDEVA STDEVP STDEVPA VAR VARA VARP VARPA