Table 50 lists mathematical functions, which allow you to perform many mathematical operations in formulas:
Table 50. List of Mathematical Functions
Function | Operation |
---|---|
Return the average value of the values in the specified member list | |
Return the value of e (the base of natural logarithms) raised to power of the specified expression | |
Return the next-lowest integer value of a member or expression | |
Return the logarithm to a specified base of a specified expression | |
Return the maximum value among the expressions in the specified member list | |
Return the maximum value among the expressions in the specified member list, with the ability to skip zero and #MISSING values | |
Return the minimum value among the expressions in the specified member list | |
Return the minimum value among the expressions in the specified member list, with the ability to skip zero and #MISSING values | |
Return the modulus produced by the division of two specified members | |
Return the value of the specified member raised to the specified power | |
Return the member or expression rounded to the specified number of decimal places | |
Return the variance (difference) between two specified members. See Calculating Variances or Percentage Variances Between Actual and Budget Values. | |
Return the percentage variance (difference) between two specified members. See Calculating Variances or Percentage Variances Between Actual and Budget Values. |