MDX Functions that Return a Number

These MDX functions return numbers or numeric value expressions. Some of them, like Sum and Round, are mathematical functions. DateDiff and DatePart help process date measures in Essbase. Others, like StrToNum, InStr, Len, and Todate, help with string processing, and some (CoalesceEmpty, NonEmptyCount) help you navigate around empty cells.

Table 4-29 MDX Numeric Value Functions

Function	Result
Abs	Returns absolute value of an expression.
Aggregate	Aggregates the Accounts member based on its Time Balance behavior.
Avg	Returns the average of values found in the tuples of a set.
Case	Performs conditional expressions.
CellValue	Returns the numeric value of the current cell.
CoalesceEmpty	Returns the first non #Missing value from the given value expressions.
Count	Returns the count of the number of tuples in a set.
DateDiff	Returns the difference between two input dates.
DatePart	Returns a number representing a date part (such as Week).
EnumText	Returns the text value corresponding to a numeric value in a text list.
EnumValue	Returns the internal numeric value for a text value in a text list.
Exp	Returns the exponent of an expression.
Factorial	Returns the factorial of an expression.
IIF	Performs a conditional test, and returns an appropriate numeric expression or set depending on whether the test evaluates to true or false.
InStr	Returns a number specifying the position of the first occurrence of one string within another.
Int	Returns the next lowest integer value of an expression.
Len	Returns length of a string.
Ln	Returns the natural logarithm of an expression.
Log	Returns the logarithm of an expression to a specified base.
Log10	Returns the base-10 logarithm of an expression.
Max	Returns the maximum of values found in the tuples of a set.
Median	Returns the value of the median tuple of a set.
Min	Returns the minimum of values found in the tuples of a set.
Mod	Returns the modulus (remainder value) of a division operation.
NonEmptyCount	Returns the count of the number of tuples in a set that evaluate to nonempty values.
NTile	Returns a division number of a tuple in a set.
Ordinal	Returns a number indicating depth in the hierarchy.
Percentile	Returns the value of the tuple that is at a given percentile of a set.
Power	Returns the value of the numeric value expression raised to power.
Rank	Returns the numeric position of a tuple in a set.
RealValue	Returns a value for the specified member or tuple without the inherited attribute dimension context.
Remainder	Returns the remainder value of the numeric value expression.
Round	Rounds a numeric value expression to the specified number of digits.
Stddev	Calculates standard deviation based on a sample.
Stddevp	Calculates standard deviation based on a population.
StrToNum	Converts a string to a number.
Sum	Returns the sum of values of tuples in a set.
Todate	Converts a date string to a value that is usable in calculations.
Truncate	Removes the fractional part of a numeric value expression, returning the integer.