add_or_null

arithmetic-functions add_or_null

syntax

  • add_or_null(a, b)

definition

add_or_null(a, b) results in the element-by-element addition of corresponding values of the data items: a and b. If the result of the addition exceeds the MinValue or MaxValue of the value-type, the add_or_null function results in the value null.

applies to

Data items with Numeric, Point, or String value-type.

conditions

  1. Domain units of the arguments must match or be void, (literals or parameters can be added to data items of any domain).
  2. Arguments must have matching:
    • value type
    • metric

example

1. attribute<uint8> add_or_null_AB (ADomain) := add_or_null(A, B);

A B add_or_null_AB
0 1 1
1 null null
200 54 254
50 100 150
222 111 null

ADomain, nr of rows = 5

see also