Numeric Field Formats
The numeric field formats set in the Data Table Settings pane are used in the Format field for numbers that will be displayed in the dashboards, either in tables, filters, or in visualization pop-up details.
Useful formats include:
Format |
Description |
0.0 % |
Produces a percentage with a single decimal place. The percentage will be 100 times the original value. |
0.0 ‘%’ |
Displays a number and adds a percentage suffix. In this case the number will not be multiplied. |
#,##0 |
Produces a number without any decimal places plus the thousand separator |
#,##0.00 |
Produces a number with two decimal places plus the thousand separator. |
#,##0.0000 |
Produces a number with four decimal places plus the thousand separator. |
#,##0.## |
Produces a number with two decimal places if a decimal exists. Otherwise no decimal will be displayed. |
#,##0;(#,##0) |
Produces a number without any decimal places, and with a thousand separator, where negative numbers are displayed in parenthesis |
n |
Produces numbers with two decimal places (for example, #,##0.00). |
P |
Produces percentages with two decimal places (for example, 0.00 %). |
#,##0; #,##0 |
Similar to #,##0, except that there will be no distinction between negative and positive numbers. This number format can be used to display Ranking on a Line Graph producing a Bump Chart. |
0% |
Produces a percentage without any decimal place. The percentage will be 100 times the original value. |
0.00% |
Produces a percentage with two decimal places. The percentage will be 100 times the original value. |
0.00%;(0.00%) |
Produces a percentage with two decimal places where negative numbers are displayed in parenthesis. |
$#,##0 |
Produces a number without any decimal places, and with a thousand separator with a USD prefix. |
NOTE |
You can also specify a customized format.
|