Numeric fields are fields with display types of Number, Currency and Decimal.
The following assignment operators are used with numeric fields.
Operator | Meaning |
+= | Add |
-= | Subtract |
*= | Multiplication |
/= | Division |
Null numeric field values have special treatment. When a numeric field has a null value, and is being used in a calculation, it is assumed the value is zero. This avoids errors and null results occuring. However, tests on numeric type fields with value qualifiers such as numeric_field.{is null} and numeric_field.{not null} return true or false depending on whether there is a null value.