mul_or_null

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