Numeric Display Format
The Format text boxes let you specify the format of numbers that will be displayed in the dashboards, either in tables, filters, or in visualization pop-up details.
Formats |
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, and with a thousand separator. |
#,##0.0 |
Produces a number with one decimal place, and the thousand separators. |
#,##0.00 |
Produces a number with two decimal places, and the thousand separators. |
#,##0.0000 |
Produces a number with four decimal places, and the thousand separators. |
#,##0;(#,##0) |
Produces a number without any decimal places, and with a thousand separator, where negative numbers are displayed in parenthesis. |
#,##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. |