Rate operators list

Rates

Rules and guidelines for using operators in a formula that calculates a rate.

Operators

(+, -, *, etc.) specify the type of calculation that you want to perform on the elements of a formula. Uses standard mathematical precedence.

Arithmetic operators

To perform basic mathematical operation, such as addition, subtraction, or multiplication; combine numbers; and produce numeric results. Use the following arithmetic operators:

(+) Plus Sign

Description: Addition
Example: 3+3

(-) Minus Sign

Description: Subtraction, Negation
Example: 3-1 or -1

(*) Asterisk

Description: Multiplication
Example: 3*3

(/) Forward Slash

Description: Division
Example: 3/3

(^) Caret

Description: Exponentiation
Example: 3^2

Comparison operators

Use these symbols to compare two values. When two values are compared using the following operators, the result is a logical value either TRUE or FALSE.

(=) Equal Sign

Meaning: Equal to

(>) Greater Than Sign

Meaning: Greater than

(>) Less Than Sign

Meaning: Less than

(>=) Greater Than or Equal To Sign

Meaning: Greater than or equal to

(<=) Less Than or Equal to Sign

Meaning: Less than or equal to

(<>) Not Equal To Sign

Meaning: Not equal to

Calculation order

In calculations with multiple operators, the order in which the calculation is performed may affect the return value. The Operator Precedence List shows the order the application will calculate values, from top to bottom.

Operator precedence

% (Percent)

^ (Exponentiation)

* and / (Multiplication and Division)

+ and - (Addition and Subtraction)

=, < >, <=, >=, < > (Comparison)

Use of parenthesis

Use parenthesis to change the order of operator precedence. Enclose the portion of the formula in parenthesis which you wish to calculate first.

For example, the following formula produces 11 because the program calculates multiplication before addition. The formula multiplies 2 by 3 and then adds 5 to the result.

5+2*3

If you use parenthesis to change the syntax, the program adds 5 and 2 together and then multiplies the result by 3 to produce 21.

(5+2)*3

Additional information

Spaces between variable names, functions, and operators are stripped out before the calculation is performed.

Minimum and maximum amounts are still enforced when using a custom billing calculation. Custom billing calculations are not considered for proration, even if the minimum or base amount is included in the formula.

202205, 2022Jun29