1. Calculation functions
  2. All functions
  3. Numeric functions

Anaplan provides a range of functions for numeric and mathematical use.

Title Description

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).


Use DIVIDE to divide one number by another.


The EXP function raises the mathematical constant e, or Euler's number, to the power you specify.


The FIRSTNONZERO function searches through two or more numeric arguments and returns the first value that is not zero.


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.


The LOG function returns the logarithm of a number to the base you specify.


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.


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.


The MOD function returns the remainder when one number is divided by another, or modulo.


The MROUND function rounds a value to the nearest multiple of a number.


The POWER function raises a number to the power you specify.


The ROUND function rounds a value to a specified number of decimal places, an integer, or a power of 10.


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.


The SQRT function calculates the square root of a number.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.