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
- Domain units of the arguments must match or be void, (literals or parameters can be added to data items of any domain).
- 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