Operators

Use the following operators in a RecordBox, RecordArea, or FormattedRecordArea.

Operator Examples Description
a + b SubTotal + Freight Adds two numbers together or concatenates two strings.
a - b Total - Tax Subtracts b from a.
a / b Total / 12 Divides a by b.
a * b UnitPrice * Quantity Multiplies two numbers together.
a % b QuantityA % QuantityB Computes the remainder after dividing a by b.
- a - Price Numeric negation of a
a == b QuantityA == QuantityB Returns true if a is equal to b.
ab QuantityA > QuantityB Returns true if a is greater than b.
a < b QuantityA < QuantityB Returns true if a is less than b.
a >= b QuantityA >= QuantityB Returns true if a is greater or equal to b.
a <= b QuantityA <= QuantityB Returns true if a less than or equal to b.
a != b QuantityA != QuantityB Returns true if a is not equal to b.
!bool !BoolA Returns boolean negation (returns true if operand is false).
a | b QuantityA | QuantityB Returns the logical disjunction on two Boolean expressions, or a bitwise disjunction on two numeric expressions.
a & b QuantityA & QuantityB Returns the logical conjunction on two Boolean expressions, or a bitwise conjunction on two numeric expressions.
a ~ b QuantityA ~ QuantityB Returns the bitwise complement operation on its operand, which has the effect of reversing each bit.
a ^ b QuantityA ^ QuantityB Returns the logical exclusion on two Boolean expressions, or a bitwise exclusion on two numeric expressions.

Operators can be used in the Field property of a RecordBox.

Operators are enclosed within pound signs in a RecordArea or FormattedRecordArea:

     Hello #FirstName# #LastName#,  
           Your order total is #SubTotal + Freight#.
     Sincerely,
     Order Department

In this topic