Formatting numbers

Data Analyzer provides common formats to change how numbers appear. You can, for example, display numbers with or without decimal values, in scientific notation, as a percentage, or as currency with the appropriate symbol. This section discusses numeric data formats and describes how you can apply these formats to data in a cross tab. Table 2-1 shows the standard number formats that Data Analyzer supports.

Table 2-1

Standard number formats

Format	Example of data display
Currency	$6,067.45 or ¥6067 or 6.067,45€, depending on the symbol, symbol position, decimal place, and thousands-separator values that you set.
Custom	$123 or 123$ or 1,23, depending on the decimal places, separator, symbol, and symbol position that you specify.
Fixed	6067 or 6067.5 or 6,067.45, depending on the decimal place and thousands-separator values that you set.
General Number	6066.45 or 6066.5 or 6066, depending on the original value. This format displays up to two decimal places. Numbers with more than two decimal places round to two decimal places. Whole numbers and numbers with one or two decimal places appear in their original format.
Percent	45% or 45.8% or %45, depending on the symbol position and decimal place values that you set. This format multiplies the original value by 100 and adds the percent (%) symbol.
Scientific	2E04 or 2.67E04, depending on the decimal place value you set. The number after the E represents the exponent of 10. For example, 2.67E04 means 2.67, multiplied by 10, raised to the fourth power.
Unformatted	Restores the formats to those in the original cross tab.

How to apply a number format

1	Right-click a cell. From the menu, choose Format→Format Data.

2	In Number column format, select from the following options:

Select a format from the Format Number as drop-down list. For example, you can format the credit limit as currency in dollars ($), as shown in Figure 2-23.

Select the appropriate options from the remaining drop-down lists.

Choose OK.

Figure 2-23

Setting number column format

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2