---
title: "Formatting the Auto Total Row for Numeric Columns"
canonical: "https://support.appfire.com/space/TBL/74815084/Formatting%20the%20Auto%20Total%20Row%20for%20Numeric%20Columns"
format: markdown
---
> Macro (div)
> 
> ### On this page
> 
> > Macro (toc)

# Overview

This page outlines an example of how to style the Auto Total row for numeric columns using the [CSV macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815945), [Table Plus macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815966), or [Attachment Table macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74814506), which are part of the [Advanced Tables for Confluence](https://appfire.atlassian.net/wiki/spaces/TBL/overview) add-on.

This example assumes your data itself contains the formatting you want, such as comma separators and dollar signs. The instructions below will ensure that when you choose to have an Auto Total row, it too is similarly styled.

Since release 5.4, there are more capabilities to control table display characteristics. Specifically, setting the table class (default is **confluenceTable**), table style, and row styles. See [Common Table Capabilities](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815958) for more details.

# Macro Browser Input

### <span style="color: #333333">Select this Macro</span>

|  |  |
| --- | --- |
| *Macro Name* | *Any of the following:*<br>- CSV (Comma Separated Values)
- Table Plus
- Attachment Table |
| *Macro Syntax* | *Any of the following:*<br>- {csv}
- {table-plus}
- {attachment-table} |

### <span style="color: #333333">Define these Parameters/Values</span><span style="color: #333333"> </span>

<span style="color: #333333">This Auto Total row can be styled by setting the </span>*<span style="color: #333333">columnTypes</span>*<span style="color: #333333"> parameter to:</span>

|  |  |
| --- | --- |
| *Auto total row* | selected |
| Column types | ```
s,f"0,0",f"$0,0.00"
``` |

> ℹ️ See [Formatting Options for Numeric Rows](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74814909) for a full list of available formatting options.

### <span style="color: #333333">Screenshot</span>

![image](media://ccace028-2f4c-4655-ad6f-f207a569c050)

 

# Wiki Markup Input

For a table built using the [CSV macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815945):

```plaintext
{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

![image](media://1791737c-667b-472a-866e-00415ad6bc18)

# Other Examples

Visit our [full list of product examples](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815984) for additional inspiration!