# @formats

## Quick Reference

```sql
-- @formats: integer, currency 
```

## Valid Values

`List`

@formats must be a comma separated list of formats that map to the columns used within the @series or @secondary-series

* none
* integer
* currency
* percent

## Full Example

```sql
-- @chart: bar
-- @title: Bar Chart With Formats
-- @subtitle: An example bar chart with formats
-- @formats: currency
SELECT 
Channel,
sum(Amount) as Total_Sales
FROM Sales
WHERE Status = 'Won'
GROUP BY Channel
ORDER BY Total_Sales DESC;
```

<figure><img src="https://4045370218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB0xzzR5x0BnQ6kHixlzd%2Fuploads%2FOw0vZ28ufQvAOtgvyYgL%2Fimage.png?alt=media&#x26;token=b064e2f0-e01a-402b-8eb0-29ca80d9c36b" alt=""><figcaption><p>An example bar chart with currency formatting applied to the series</p></figcaption></figure>

## Use Cases

Formats allows you to visually improve the look of number data in your charts to be more clear and visually appealing.

## Example Charts

<table data-card-size="large" data-view="cards"><thead><tr><th data-card-target data-type="content-ref"></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><a href="../../charts/formatting-and-rendering/formats">formats</a></td><td></td><td></td><td></td><td><a href="https://4045370218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB0xzzR5x0BnQ6kHixlzd%2Fuploads%2FOw0vZ28ufQvAOtgvyYgL%2Fimage.png?alt=media&#x26;token=b064e2f0-e01a-402b-8eb0-29ca80d9c36b">bar_chart_with_formats_example.png</a></td></tr><tr><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>
