Use arithmetic operators to perform mathematical calculations on numeric data.

The following table lists the arithmetic operators in order of precedence in the transformation language:

If you perform arithmetic on a null value, the function returns NULL.

When you use arithmetic operators in an expression, all of the operands in the expression must be numeric. For example, the expression

1 + '1'

is not valid because it adds an integer to a string. The expression

1.23 + 4 / 2

is valid because all of the operands are numeric.