mul_or_null - ObjectVision/GeoDMS GitHub Wiki

Arithmetic functions mul_or_null

syntax

  • mul_or_null(a, b)

definition

mul_or_null(a, b) results in the element-by-element multiplication of corresponding values of the data items: a and b. If the result of the multiplication exceeds the MinValue or MaxValue of the value type, the mul_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> mul_or_null_AB (ADomain) := mul_or_null(A, B);

A B mul_or_null_AB
0 1 0
1 null null
2 54 108
5 100 null
2 111 222

ADomain, nr of rows = 5

see also

⚠️ **GitHub.com Fallback** ⚠️