Math Functions

Math Function

Description

Abs

Returns the absolute value of a numeric expression.

Average

Returns the average of a specified field or expression across a collection.

Avg

Returns the average of a specified field or expression across a collection.

BankRound

Returns the number rounded to the number of decimal places using the rules of bankers rounding.

Divide

Divides the value of one numeric expression by another.

Exp

The Exp function returns e raised to a given power.

Exp

Returns the end-of-period future value for a series of payments given the interest rate, number of periods, payment amount, and initial principal

IPMT

Returns the end-of-period interest payment for given present value at specified rate for specified period.

Largest

Returns the largest value in a list of values.

Log

Returns the natural (base e) logarithm of a specified number.

Minus

Subtracts the value of one numeric expression from another.

Mod

Divides two numbers and returns only the remainder.

Multiply

Multiplies the value of one numeric expression by another.

NumDigits

Returns the number of digits in a given number, not counting trailing zeros to the right of the decimal point nor any leading zeros.

Percent

The Percent function returns (value * percent) / 100.0.

Plus

Adds the value of one numeric expression to another.

PMT

Returns the end-of-period payment for given present value at specified rate for specified period. Note: The result is not negated as a debt. (e.g. PMT(0, 10, 10000) = 1000.00 not -1000.00)

Power

Takes the value of one numeric expression to the power of the exponent value.

PPMT

Returns the end-of-period principal payment for given present value at specified rate for specified period.

PV

Returns the end-of-period present value for a series of future payments given, the interest rate, the number of periods, the payment amount, and the future value remaining after all payments are made

Random

Returns a random integer between the specified minimum and maximum values.

Rate

Returns the end-of-period interest rate which must be applied to the present value in order to arrive at the future value when compounded over the given number of periods

Round

The Round function rounds a number to a specified number of decimal places.

RoundDown

The RoundDown function rounds a number down to a specified number of decimal places.

RoundUp

The RoundUp function rounds a number up to a specified number of decimal places.

Smallest

Returns the smallest value from a list of values.

Sqrt

The Sqrt function returns the square root of a number.

Sum

Returns the sum of a specified member or expression across a collection.