Round
Rounds a number, or every number in a column, to a set number of decimal places. Use it to tidy computed values, such as per-unit costs or allocated percentages, before they land in a report or an output table.
Inputs
| Input | Accepts | Required |
|---|---|---|
Value | Any | Yes |
Decimals | Value (a single number) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Any |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Decimals | 2 | Number of decimal places to keep. Default 2. Use 0 for whole numbers. Halves round away from zero, the same convention as Excel's ROUND (2.5 becomes 3, -2.5 becomes -3). |
Example
Dividing quarterly overhead of $1,847,300 across 1,237 headcount gives $1,493.37186... per employee. Wire the result into Round with Decimals set to 2 and it becomes a clean $1,493.37. Set Decimals to 0 when a summary table should show whole dollars only.
Tips
Rounding is best saved for the last step of a calculation chain. Rounding intermediate values (a rate, then a payment, then a total) compounds small errors; round once at the end instead.