Rate_operators_list

Rate operators list

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

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • Rate custom option list

      Use a custom option to activate special billing functionality. The options in this list will change how Connect calculates a rate. If you need assistance, please contact customer service at (800) 243-8275 for more information. Use a custom formula to ...

    • How do I add a rate?

      Organization use rates to calculate a billed amount for electricity, water, sewer, and other services that bill based on the amount used by a customer. The rate allows you to customize how the billed amount is calculated and define what happens when ...

    • How do I manage rate levels on a rate?

      When a tiered rate structure exists, the rate levels will help you calculate the amount based on a billing quantity. The quantity represents the amount that will be billed for each level. When the level type is a rate, the quantity will be multiplied ...

    • Rate calculation variables list

      Use the calculation variables to calculate rates. CostAdjustmentFactor Description: Cost adjustment factor from the Service table. Demand Description: Demand usage. IIf Description: Conditional test function. IIf(Condition, ValueIfTrue, ValueIfFalse) ...

    • How do I format a rate number?

      Assign a rate number. Usually, a rate is created for a specific service and the service number is assigned as the first digit of the rate number. Search window, rate number Example: 101, where 1 is the service number and 01 is the rate number for the ...