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-item: 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-unit of the argument must match or be void, (literals or parameter 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