Output
Report Footer
Closes a report with totals of the columns you pick and a closing line, as an HTML section HTML Report puts at the bottom.
When to use it
Use it when a report must show its grand totals or a confidentiality line.
In a pipeline
File InputReport FooterReport TableHTML Report
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Total these columns | select | — | No totals |
| Closing line | text | — | {count} rows |
| Output column | text | — | Report Footer |
Example
Totals at the end
- Closing line={count} rows
| Region | Amount |
|---|---|
| West | 1240 |
| East | 860 |
| Region | Amount | Report Footer |
|---|---|---|
| West | 1240 | <footer>Total Amount 2,100 · 2 rows</footer> |
| East | 860 | <footer>Total Amount 2,100 · 2 rows</footer> |
Worth knowing
- Totals read money and percentages too ($1,240.00, 12%); text that is not a number is left out and counted in the note.
- Total the raw numbers: put Report Field after the footer, or the formatted text is what gets added.
- It works before or after Report Table — the order of sections in the file is always header, table, footer.