MDX Numeric Value Functions

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.