| 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> | boolean | string) |
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 |
| MIN(…x : number | <expression>) |
|
| MINA(…x : number | <expression> | boolean | string) |
|
| STDEV(…x : number | <expression>) |
|
| STDEVA(…x : number | <expression>) |
|
| STDEVP(…x : number | <expression>) |
|
| STDEVPA(…x : number | <expression>) |
|
| VAR(…x : number | <expression>) |
|
| VARA(…x : number | <expression>) |
|
| VARP(…x : number | <expression>) |
|
| VARPA(…x : number | <expression>) |
|