Mathematical Rules Functions

Mathematical operators to use in rules.

ABS
ABS returns the absolute value of a number.
ACOS
ACOS returns the angle, in radians, whose cosine is x.
ASIN
ASIN returns the angle, in radians, whose sine is x.
ATAN
ATAN returns the angle, in radians, whose tangent is x. The result is between -pi/2 and +pi/2.
COS
COS returns the cosine of an angle expressed in radians.
EXP
EXP returns the natural anti-log of a number.
INT
INT returns the largest integer that is less than or equal to a specified value.
ISUND
ISUND returns 1 if a specified value is undefined; otherwise it returns 0.
LN
LN returns the natural logarithm (base e) of a number.
LOG
LOG returns the base 10 logarithm of a positive number.
MAX
MAX returns the largest number in a pair of values.
MIN
MIN returns the smallest number in a pair of values.
MOD
MOD returns the remainder of dividing a number by a divisor.
RAND
RAND generates a random number that is uniformly distributed between 0 and 1. The random number generator is seeded when Planning Analytics is loaded.
ROUND
ROUND rounds a given number to the nearest integer. Rounding can be done in a variety of ways.
ROUNDP
ROUNDP rounds a given number at a specified decimal precision.
SIGN
SIGN determines if a number is positive, negative, or zero. The function returns 1 if the number is positive, -1 if the number is negative, and 0 if the number is zero.
SIN
SIN returns the sine of a given angle.
SQRT
SQRT returns the square root of a given value.
TAN
TAN returns the tangent of a given angle.

Parent topic: Rules functions