## 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

### Note

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.

## Comments

0 comments

Please sign in to leave a comment.