| Excerpt |
|---|
Returns the value of summing the first argument and the second argument. Equivalent to the + operator. |
- Each argument can be a literal Integer or Decimal number, a function returning a number, or a reference to a column containing numeric values.
| Info |
|---|
NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators. |
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: add(2,3) as:'five' |
|---|
|
add(2,3) |
Output: Returns the sum of the values 2 and 3.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:add(value1, value2) |
|---|
|
add(value1, value2) |
| Argument | Required? | Data Type | Description |
|---|
| value1 | Y | string | The first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types. |
| value2 | Y | string | The first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types. |
value1, value2
Integer or Decimal expressions, column references or literals to sum together.
- Missing or mismatched values generate missing string results.
| Required? | Data Type | Example Value |
|---|
| Yes | Literal, function, or column reference returning an Integer or Decimal value | myScore * 10 |
Example - Numeric Functions
| Include Page |
|---|
| EXAMPLE - Numeric Functions |
|---|
| EXAMPLE - Numeric Functions |
|---|
|
