Supported Operators

Arithmetic

Comparision

Overview

The order of operator precedence in the formulas

fiber_manual_recordConvert percentages (%)
fiber_manual_recordPerform exponentiation (^)
fiber_manual_recordPerform multiplication (*) and division (/), which are of equal precedence
fiber_manual_recordPerform addition (+) and subtraction (-), which are of equal precedence
fiber_manual_recordConcatenate text operator (&)
fiber_manual_recordPerform comparisons (=, <>, <, <=, >, >=)

Arithmetic operators

These operators support only NUMERIC operands. If at least one of the operands is detected as non-NUMERIC at compile time, it results in an error. An absent operand is considered a zero.

Comparison operators

The = and <> operators support NUMERIC, ALPHANUMERIC and BOOLEAN operands. If the operands have different types, an = operator results in false while a <> operator results in true. An absent NUMERIC operand is considered a zero, an absent ALPHANUMERIC operand is considered an empty string and an absent BOOLEAN operand is considered false.

All comparison operators support only NUMERIC operands. If at least one of the operands is detected as non-NUMERIC at compile time, it results in an error. An absent operand is considered a zero.