Rules & Numeric Fields

Numeric fields are fields with display types of Number, Currency and Decimal.

The following assignment operators are used with numeric fields.

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.