Add
arithmetic-functions addition (+)
syntax
- add(a, b, …) or add_list(a, b, …)
- a + b + …
definition
add(a, b, …) or a + b + … results in the element-by-element addition of corresponding values of the data items: a, b, … ..
add_list is a synonym for add
If the result of the addition exceeds the MinValue or MaxValue of the value-type, an error is generated. Use the add_or_null function if a null value is requested in these cases.
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<float32> addABC (ADomain) := add(A, B, C);
2. attribute<float32> addABC (ADomain) := A + B + C;
| A | B | C | addABC |
|---|---|---|---|
| 0 | 1 | 0 | 1 |
| 1 | -1 | 1 | 1 |
| -2 | 2 | 4 | 4 |
| 3.6 | 1.44 | 7 | 12.04 |
| 999 | 111 | -5 | 1105 |
ADomain, nr of rows = 5