Arithmetic Operators
Operator |
Description |
---|---|
Addition (3 + 3) |
|
Division (3 / 2) |
|
Exponentiation (3 ^ 2) |
|
Multiplication (2 * 3) |
|
Subtraction (5 - 2) Negation (-4) |
If a field included in an addition, subtraction, multiplication, division or comparison operation is empty or null, the value "0" (zero) is used for the field value. The following formula is an exception to this rule:
IF([Sample Field] = 0, "TRUE","FALSE")
In this formula, the Sample Field is not populated with the value "0" if the field is empty or null. Instead, this formula returns TRUE when the Sample Field is empty or null.