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

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<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

see also

• add_or_null
• string concatenation
• add polygon