Arithmetic Functions
4 functions for basic arithmetic against a second operand. The source column is always the implicit first input.
| Function | Syntax | Parameters | Notes |
|---|---|---|---|
add | add(column, operand) | operand — column, literal, or expression. | |
subtract | subtract(column, operand) | operand — column, literal, or expression. | |
multiply | multiply(column, operand) | operand — column, literal, or expression. | |
divide | divide(column, operand) | operand — column, literal, or expression. | Guards against division by zero using F.nullif(operand, 0) — returns null instead of raising an error. |