MDX Numeric Value Functions

  • Article

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>])