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

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.