add_or_null - ObjectVision/GeoDMS GitHub Wiki

Arithmetic functions add_or_null

• add_or_null(a, b)

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.

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

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

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

• add