Arithmetic operators

You can process numeric terms in comparison expressions using the arithmetic operators:

Operator

Meaning

+

Add

-

Minus

*

Multiply

/

Divide

%

Integer divide (divide and return the integer part of the result)

//

Remainder (divide and return the remainder--not modulo, because the result might be negative)

**

Power® (raise a number to a whole-number power)

Prefix -

Same as the subtraction: 0 - number

Prefix +

Same as the addition: 0 + number

You can use these operators to produce an intermediate result that you can compare with another term. For example, given these fields:

#6

Contains a numeric value representing an employee's annual salary.

#15

Contains a numeric value representing his annual travel allowance.

#23

Contains a numeric value representing his annual bonus.

you can use this comparison to select records for employees with a combined annual payment of greater than $100,000:

(#6 + #15 + #23) > 100000

For another example, with these fields:

#45

Contains the number of sick days an employee is entitled to annually.

#46

Contains the number of sick days an employee has used in the current year.

you can use this comparison to select records for employees who have used 50% or more of their sick days entitlement:

(#46 / #45) >= .5

The order of precedence of arithmetic operators is as follows (highest is at the top):

Operator

Meaning

+ - ¬ \

Prefix operators

**

Power®

* /

Multiply and divide

+ -

Add and subtract