Formatting of numbers shown on report output may be specified in a number of places i.e.
- in Report Definitions
- in Crosstabulation Definitions
- by applying formatting to any range of selected cells on the Report Viewer
Types of Number Format
Any valid number format may be used, similar to those in Excel, # for a potential figure, 0 for a certain figure. Examples include:
- #0.00 (produces fixed 2 decimal places e.g. 2.77)
- #,##0 (produces numbers with a thousands separator e.g. 1,267)
Conditional Number Formatting
A number format can have up to three sections of code, separated by semicolons. These code sections define formats in the order positive numbers, negative numbers and zero values.
For example, the format #,##0.00;(#,##0.0);0.0 would display values as below:
Percentage Number Formatting
This formatting only currently works with the following:
- Analysis vs Time reports using Report Definitions (see Other Calculated Line Types)
- Crosstabulation Analysis (see Calculated Crosstab Columns)
- Crosstabulation Analysis using Report Definitions
Adding a percentage sign to a number format will multiply the result by 100 and add a '%' sign to the end. If you wish to add a '%' sign to the number that is already expressed as a percentage, add \% to the end.
For example, the format 0.00% and 0.00\% would display values as below for an output of 52.4 respectively:
5,240.00% (52.4 x 100 with a percentage symbol applied) 52.4% (52.4 with a percentage symbol applied)
Changing numerical display formats
Should you wish to display all ASP outputs with a different number of decimal places to the standard 2 places, please Contact Support who will advise you regarding changing this.
Please sign in to leave a comment.