Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)

Some numeric functions are described further in other sections of this guide. Following is the complete list of the MDX numeric value functions:

<numeric_value_function> ::= AGGREGATE(<set> [, <numeric_value_expression>]) AVG(<set>[, <numeric_value_expression>]) CORRELATION(<set> , <numeric_value_expression> [, <numeric_value_expression>]) COVARIANCE(<set>, <numeric_value_expression> [, <numeric_value_expression>]) COUNT(<set>[, INCLUDEEMPTY]) LINREGINTERCEPT(<set>, <numeric_value_expression> [, <numeric_value_expression>]) LINREGPOINT(<numeric_value_expression>, <set>, <numeric_value_expression> [, <numeric_value_expression>]) LINREGR2(<set>, <numeric_value_expression> [, <numeric_value_expression>]) LINREGSLOPE(<set>, <numeric_value_expression> [, <numeric_value_expression>]) LINREGVARIANCE(<set>, <numeric_value_expression> [, <numeric_value_expression>]) MAX(<set>[, <numeric_value_expression>]) MEDIAN(<set>[, <numeric_value_expression>]) MIN(<set>[, <numeric_value_expression>]) RANK(<tuple>, <set>) STDEV(<set>[, <numeric_value_expression>]) SUM(<set>[, <numeric_value_expression>]) VAR(<set>[, <numeric_value_expression>])

1998-2001 Microsoft Corporation. All rights reserved.