##### Page tree

Contents:

NOTE:  Designer Cloud Powered by Trifacta Educational is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

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.

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators.

Wrangle vs. SQL: This function is part of Wrangle , a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

## Basic Usage

Output:
Returns the sum of the values `2` and `3`

## Syntax and Arguments

ArgumentRequired?Data TypeDescription
value1YstringThe first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types.
value2YstringThe 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.

Usage Notes:

Required?Data TypeExample Value
YesLiteral, function, or column reference returning an Integer or Decimal value`myScore * 10`

## Examples

### Example - Numeric Functions

This example demonstrates how to use numeric functions to perform computations in your recipe steps.

Functions:

ItemDescription
ADD Function Returns the value of summing the first argument and the second argument. Equivalent to the `+` operator.
MOD Function Returns the modulo value, which is the remainder of dividing the first argument by the second argument. Equivalent to the `%` operator.
NEGATE Function Returns the opposite of the value that is the first argument. Equivalent to the `-` operator placed in front of the argument.
SUBTRACT Function Returns the value of subtracting the second argument from the first argument. Equivalent to the `-` operator.
MULTIPLY Function Returns the value of multiplying the first argument by the second argument. Equivalent to the `*` operator.
DIVIDE Function Returns the value of dividing the first argument by the second argument. Equivalent to the `/` operator.
LCM Function Returns the least common multiple shared by the first and second arguments.

Source:

ValueAValueB
82
104
1510
56

Transformation:

Execute the following transformation steps:

Transformation Name `New formula` `Single row formula` `ADD(ValueA, ValueB)` `'add'`

Transformation Name `New formula` `Single row formula` `SUBTRACT(ValueA, ValueB)` `'subtract'`

Transformation Name `New formula` `Single row formula` `MULTIPLY(ValueA, ValueB)` `'multiply'`

Transformation Name `New formula` `Single row formula` `DIVIDE(ValueA, ValueB)` `'divide'`

Transformation Name `New formula` `Single row formula` `MOD(ValueA, ValueB)` `'mod'`

Transformation Name `New formula` `Single row formula` `NEGATE(ValueA)` `'negativeA'`

Transformation Name `New formula` `Single row formula` `LCM(ValueA, ValueB)` `'lcm'`

Results:

With a bit of cleanup, your dataset results might look like the following:

828-80416610
10420-1022.540614
151030-1551.5150525
5630-550.83333333330-111

• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:

• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page:
• Page: