Number Formatting

Overview

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.

<POSITIVE>;<NEGATIVE>;<ZERO> 
For example, the format #,##0.00;(#,##0.0);0.0 would display values as below:
1,234.56
(1,234.6)
0.0

Percentage Number Formatting

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.