+

addition

-

subtraction

*

multiplication

/

division

\

division of integers

^

exponentiation

mod

mod

& string concatenation

concatenate

Multiply the contents of two fields from the source file

Source field names are Quantity and Price. Target field name is TOTAL SALE.

Multiply the contents of one field from the source file by a literal value (add 7.25% sales tax)

Source field name is Total. Target field name is GRAND TOTAL.

Divide the contents of one field by the contents of another field from the source file

Source field names are Total and Quantity. Target field name is PRICE PER.

Add the contents of two fields from the source file

Source field names are Total and Tax. Target field name is GRAND TOTAL.

Multiply two numeric operands

result = operand1 * operand2

Numeric operands are promoted to double precision values before being multiplied. If both operands are integer values and the result can be represented as an integer, then the operator returns an integer value.

If one or both operands are Null, then the result is Null. All other values are treated as a numeric value of zero.

The following expression returns the value of the contents of the field Salary multiplied by the constant 2.

This expression returns the value of the contents of the Price Per field multiplied by the contents of the Quantity field:

Add two numeric operands or concatenates two string operands

result = operand1 + operand2

The + operator treats operands as numbers (unless both are dates, and one contains only time information). So if either or both is a string, it is treated as a number. For string concatenation, the & operator is preferred to the + operator because there is less ambiguity.

Numeric operands are promoted to double precision values before being added. If both operands are integer values and the result can be represented as an integer, then the operator returns an integer value.

If one or both operands are Null, then the result is Null.

The following expression adds the contents of two numeric fields, Bonus and Salary:

The following expression adds a constant value to the value in an existing field.

For more information, see Arithmetic Operators.

Find the difference between two numeric operands or change the sign of a numeric operand

Syntax 1: result = operand1 - operand2
Syntax 2: result = - operand

The first form of the operator (Syntax 1) calculates the difference between two numeric values. It is the subtraction operator. In the second form (Syntax 2), the operator is arithmetic negation operator.

Numeric operands are promoted to double precision values before performing the operation. If both operands are integer values and the result can be represented as an integer, then the operator returns an integer value.

If one or both operands are Null, then the result is Null. All other values are treated as a numeric value of zero.

The following expression calculates the difference between two numeric fields List Price and Price:

The following expression calculates the difference between a numeric field and a constant.

Integer division operator. Divide two numbers and return the integer result.

result = operand1 \ operand2

If one or both operands are Null, then the result is Null. All other nonnumeric values (empty strings, strings composed of letters) are treated as a numeric value of zero

The following example determines if the field Quantity contains an even number

Division operator. Divide two numbers and return a result.

result = operand1 / operand2

Numeric operands are promoted to double precision values before performing the operation. If both operands are integer values and the result can be represented as an integer, then the operator returns an integer value.

If one or both operands are Null, then the result is Null. All other nonnumeric values (empty strings, strings composed of letters) are treated as a numeric value of zero.

The following example calculates the average monthly sales by dividing the contents of the Annual Sales field by the constant value of 12:

The following expression divides the numeric contents of one field by the numeric contents of another field:

Raise a number to the power of an exponent

result = number ^ exponent

Numeric operands are promoted to double precision values before performing the operation. If both operands are integer values and the result can be represented as an integer, then the operator returns an integer value.

If one or both operands are Null, then the result is Null. All other values are treated as a numeric value of zero.

The following expression returns the value of the field Distance squared:

Divide two numbers and returns only the remainder

result = operand1 Mod operand2

Mod is a shortened term for modulus. Mod divides operand1 by operand2 (rounding floating-point numbers to integers) and returns only the remainder as result. The operands can be any numeric expression.

The data type of result is usually an Integer or a Long. However, result is a Null if one or both of the operands are Null expressions. Any operand that is Empty is treated as 0 (zero).

This example divides 200000 by 9 and determines the remainder. It returns 2.

200000 Mod 9

Mod is calculated as follows:

Where:

1 Mod 12

1 - 12 * (1 \ 12)

1

2 Mod 12

2 - 12 * (2 \ 12)

2

3 Mod 12

3 - 12 * (3 \ 12)

3

4 Mod 12

4 - 12 * (4 \ 12)

4

5 Mod 12

5 - 12 * (5 \ 12)

5

6 Mod 12

6 - 12 * (6 \ 12)

6

7 Mod 12

7 - 12 * (7 \ 12)

7

8 Mod 12

8 - 12 * (8 \ 12)

8

9 Mod 12

9 - 12 * (9 \ 12)

9

10 Mod 12

10 - 12 * (10 \ 12)

10

11 Mod 12

11 - 12 * (11 \ 12)

11

12 Mod 12

12 - 12 * (12 \ 12)

0