Arithmetic
Combines two numbers or two columns of numbers with a basic operation: add, subtract, multiply, divide, raise to a power, or take a remainder. Wire in two columns and it works row by row; mix a column with a single value and that value applies to every row. The result feeds charts, KPI cards, or an output table.
Inputs
| Input | Accepts | Required |
|---|---|---|
A | Any | Yes |
B | Any | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Any |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Operation | + | One of Add, Subtract, Multiply, Divide, Power, Modulo (the symbols +, -, *, /, ^, % also work). Default is Add. Dividing by zero produces a blank (NaN) instead of an error. |
Example
Take a Monthly_PnL table with Revenue and COGS columns. Wire Revenue into input A and COGS into input B, set the operation to Subtract, and the result is a gross profit series: January's $412,000 revenue less $268,000 cost gives $144,000, and so on down the column. To convert the same revenue column from dollars to thousands, wire it into A, use a Constant of 1000 as B, and set the operation to Divide.
Tips
When the two inputs are columns of different lengths, the result stops at the shorter one. For simple one-off column math inside a table, a formula column like =[Revenue] - [COGS] is often quicker; use this node when the values come from other nodes in a pipeline.