MDX Functions that Return a Number
The following functions return a value.
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. |