# Numeric Functions

 Function Description Aggregate Returns a scalar value calculated by aggregating either measures or an optionally specified numeric expression over the tuples of a specified set. Avg Returns the average value of measures or the average value of an optional numeric expression, evaluated over a specified set. CalculationCurrentPass Returns the current calculation pass of a cube for the specified query context. CalculationPassValue Returns the value of a MDX expression evaluated over the specified calculation pass of a cube. CoalesceEmpty Coalesces an empty cell value to a number or string and returns the coalesced value. Correlation Returns the correlation coefficient of two series evaluated over a set. Count (Dimension) Returns the number of dimensions in a cube. Count (Hierarchy Levels) Returns the number of levels in a dimension or hierarchy. Count (Set) Returns the number of cells in a set. Count (Tuple) Returns the number of dimensions in a tuple. Covariance Returns the population covariance of two series evaluated over a set, using the biased population formula. CovarianceN Returns the sample covariance of two series evaluated over a set, using the unbiased population formula. DistinctCount Returns the number of distinct, nonempty tuples in a set. IIf Returns one of two values determined by a logical test. LinRegIntercept Calculates the linear regression of a set and returns the value of the intercept in the regression line, y = ax + b. LinRegPoint Calculates the linear regression of a set and returns the value of y in the regression line, y = ax + b. LinRegR2 Calculates the linear regression of a set and returns the coefficient of determination, R2. LinRegSlope Calculates the linear regression of a set, and returns the value of the slope in the regression line, y = ax + b. LinRegVariance Calculates the linear regression of a set, and returns the variance associated with the regression line, y = ax + b. LookUpCube Returns the value of an MDX expression evaluated over another specified cube in the same database. Max Returns the maximum value of a numeric expression that is evaluated over a set. Median Returns the median value of a numeric expression that is evaluated over a set. Min Returns the minimum value of a numeric expression that is evaluated over a set. Ordinal Returns the zero-based ordinal value associated with a level. Predict Returns a value of a numeric expression evaluated over a data mining model. Rank Returns the one-based rank of a specified tuple in a specified set. RollupChildren Returns a value generated by rolling up the values of the children of a specified member using the specified unary operator. Stddev Alias for Stdev (MDX). StddevP Alias for StdevP (MDX). Stdev Returns the sample standard deviation of a numeric expression evaluated over a set, using the unbiased population formula. StdevP Returns the population standard deviation of a numeric expression evaluated over a set, using the biased population formula. StrToValue Returns the value specified by an MDX-formatted string. Sum Returns the sum of a numeric expression evaluated over a set. Value Returns the value of a measure. Var Returns the sample variance of a numeric expression evaluated over a set, using the unbiased population formula. Variance Alias for Var (MDX). VarianceP Alias for VarP (MDX). VarP Returns the population variance of a numeric expression evaluated over a set, using the biased population formula.