Arithmetic Functions

4 functions for basic arithmetic against a second operand. The source column is always the implicit first input.

FunctionSyntaxParametersNotes
addadd(column, operand)operand — column, literal, or expression.
subtractsubtract(column, operand)operand — column, literal, or expression.
multiplymultiply(column, operand)operand — column, literal, or expression.
dividedivide(column, operand)operand — column, literal, or expression.Guards against division by zero using F.nullif(operand, 0) — returns null instead of raising an error.