How to format the Auto Total row for numeric columns - Cloud
Overview
This page outlines an example of how to style the row with totals of numeric columns using the Table Plus macro, CSV (Comma Separated Values) macro, or Attachment Table macro, which are part of the Advanced Tables for Confluence app. This example assumes your data itself contains the formatting you want, such as comma separators and dollar signs. The instructions given on this page ensure that when you choose to have a row with totals of numeric columns, it too is similarly styled.
Macro browser input
Select any of the macros
| Macro name |
|
| Macro syntax (Old editor) |
|
| Macro syntax (New editor - case insensitive) |
|
Define these parameters/values
| Auto total numeric columns | On |
Column types | s,f"0,0",f"$0,0.00" |
- Due to the values set in the Column types parameter, the Auto Total row also follows the same column types.
- See Formatting options for numeric rows for a full list of available formatting options.
Parameters set in the macro editor
Wiki markup input (Old editor)
For a table built using the CSV (Comma Separated Values) macro:
{csv:output=wiki|autoTotal=true|columnTypes=s,f"0,0",f"$0,0.00"}
"Item","Units","Revenue"
"Kazoos","1,368","$4,074.25"
"Accordions","445","$222,500.63"
"Mandolins","2,296","$1,033,200.00"
{csv}
Example result
Other examples
Visit our full list of product examples for additional inspiration!