The following functions return a value.
| 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. |