Perform arithmetic operations.
Math Function 
Description 
Returns the absolute value of a numeric expression. 

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

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

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

Divides the value of one numeric expression by another. 

The Exp function returns e raised to a given power. 

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

Returns the endofperiod interest payment for given present value at specified rate for specified period. 

Returns the largest value in a list of values. 

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

Subtracts the value of one numeric expression from another. 

Divides two numbers and returns only the remainder. 

Multiplies the value of one numeric expression by another. 

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

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

Adds the value of one numeric expression to another. 

Returns the endofperiod 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) 

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

Returns the endofperiod principal payment for given present value at specified rate for specified period. 

Returns the endofperiod 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 

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

Returns the endofperiod 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 

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

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

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

Returns the smallest value from a list of values. 

The Sqrt function returns the square root of a number. 

Returns the sum of a specified member or expression across a collection. 
Comments
0 comments
Please sign in to leave a comment.