OLE DB Programmer's Reference |
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.