Rules & Numeric Fields

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.