View Source

Learn more about the math functions available in Blueriq expressions, such as:

Basic math functions ADD, SUBTRACT, MULTIPLY, and DIVIDE;
More advanced math functions like SUM, PRODUCT, DIV, MOD, POWER, and LOG;
Rounding functions ROUND, ROUNDDOWN, ROUNDUP, ROUND TO MULTIPLE, ROUNDSIG, ROUNDSIGUP, and ROUNDSIGDOWN;
Comparison functions EQUAL, NOT EQUAL, LESS, LESS OR EQUAL, GREATER, and GREATER OR EQUAL;
And the special function ANNUITY.

Overview

Function	Description
`ADD (+)`	Use the '+' (plus) sign to add values of some type of number.
`SUBTRACT (-)`	Use the '-' (minus) sign to subtract values of some type of number.
`MULTIPLY (*)`	Use the '*' (asterisk) sign to multiply values of some type of number.
`DIVIDE (/)`	Use the '/' (forward slash) sign to divide values of some type of number.
`SUM`	Adds the values of a collection of numbers.
`PRODUCT`	Returns the product of the values of a collection of numbers.
`DIV`	Returns the integer portion of a division.
`MOD`	Returns the remainder of a division.
`POWER (**)`	Use the '**' operator to raise a number to a power.
`LOG`	Calculates the logarithm of a number to a base.
`ROUND`	Rounds a number value to a specified number of decimal places.
`ROUND DOWN`	Rounds a number value down to a specified number of decimal places.
`ROUND UP`	Rounds a number value up to a specified number of decimal places.
`ROUND TO MULTIPLE`	Rounds a number value to a specified multiple.
`ROUND UP TO MULTIPLE`	Rounds a number value up to a specified multiple.
`ROUND DOWN TO MULTIPLE`	Rounds a number value down to a specified multiple.
`ROUNDSIG`	Alternative syntax for ROUND TO MULTIPLE.
`ROUNDSIGUP`	Alternative syntax for ROUND UP TO MULTIPLE.
`ROUNDSIGDOWN`	Alternative syntax for ROUND DOWN TO MULTIPLE.
`EQUAL (=)`	The operator '=' compares two values and returns the boolean value TRUE if the left value is equal to the right value and FALSE otherwise.
`NOT EQUAL (!=)`	The operator '!=' compares two values and returns the boolean value TRUE if the left value is not equal to the right value and FALSE otherwise.
`LESS (<)`	The operator '<' compares two values and returns the boolean value TRUE if the left value is smaller than the right value and FALSE otherwise.
`LESS OR EQUAL (<=)`	The operator '<=' compares two values and returns the boolean value TRUE if the left value is smaller than or equal to the right value and FALSE otherwise.
`GREATER (>)`	The operator '>' compares two values and returns the boolean value TRUE if the left value is greater than the right value and FALSE otherwise.
`GREATER OR EQUAL (>=)`	The operator '>=' compares two values and returns the boolean value TRUE if the left value is greater than or equal to the right value and FALSE otherwise.
`ANNUITY`	Computes an annuity. An annuity is a terminating "stream" of fixed payments.

Overview

Functions