9/24/21
Anaplan provides a range of functions for numeric and mathematical use.
Title | Description |
---|---|
ABS | The ABS function returns the absolute value of a number. The absolute value of zero or a positive number remains the same. The absolute value of a negative number is the same number without the negative sign (the positive version). |
DIVIDE | Use DIVIDE to divide one number by another. |
EXP | The EXP function raises the mathematical constant e, or Euler's number, to the power you specify. |
FIRSTNONZERO | The FIRSTNONZERO function searches through two or more numeric arguments and returns the first value that is not zero. |
LN | Use the natural logarithm (LN) to work out the length of time it takes to achieve a unit of growth. LN returns the natural logarithm of a number, based on the constant e. This function is the inverse of the EXP function, which raises e to the nth power. |
LOG | The LOG function returns the logarithm of a number to the base you specify. |
MAX | The MAX function returns the maximum from a set of values. For a number, it returns the maximum value. For a date, it returns the latest date. |
MIN | The MIN function returns the minimum from a set of values. For a number, it returns the minimum value. For a date, it returns the earliest date. |
MOD | The MOD function returns the remainder when one number is divided by another, or modulo. |
MROUND | The MROUND function rounds a value to the nearest multiple of a number. |
POWER | The POWER function raises a number to the power you specify. |
ROUND | The ROUND function rounds a value to a specified number of decimal places, an integer, or a power of 10. |
SIGN | The SIGN function returns the sign of a number (whether it's positive, negative, or zero). The SIGN function returns 1 for positive numbers, 0 for zero, and -1 for negative numbers. |
SQRT | The SQRT function calculates the square root of a number. |