# Math Functions

• Updated

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

0 out of 0 found this helpful

<% if (previousArticle || nextArticle) { %>
<% if (previousArticle) { %>
<% if (previousTitle) { %>

#### <%= previousTitle %>

<% } %> <%= previousArticle.title %>
<% } %> <% if (nextArticle) { %>
<% if (nextTitle) { %>

#### <%= nextTitle %>

<% } %> <%= nextArticle.title %>
<% } %>
<% } %>
<% if (allItems.length > 1) { %>