Output
Report Field
Formats a column for reading — currency ($1,234.50), percent (12.50%), number (1,234.50) or date (15 Oct 2026) — in place or into a new column.
When to use it
Use it just before Report Table or an email, when raw values like 1234.5 or 2026-10-15 should read naturally.
In a pipeline
File InputReport FieldReport Table
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Format | select | — | currency |
| Decimal places | number | — | 2 |
| Currency symbol | text | — | $ |
| Date pattern | text | — | DD MMM YYYY |
| Write to column | text | — | Blank: replace the column |
Example
Amounts as dollars
- Column=Amount
- Format=Currency ($1,234.50)
| Order | Amount |
|---|---|
| A-1041 | 1234.5 |
| A-1042 | -86 |
| Order | Amount |
|---|---|
| A-1041 | $1,234.50 |
| A-1042 | -$86.00 |
Worth knowing
- Values already written as money or percentages ($1,240, 12%, (5)) are read too.
- A value that is not a number (or date) is left as it was and counted in the node's note.
- The result is text: total and sort before formatting, or format into a new column.
- Dates use the Date Format tokens: DD MMM YYYY, MM/DD/YYYY, DDDD D MMMM…