Math Functions

Perform arithmetic operations.

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.