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  
$6,067.45 or ¥6067 or 6.067,45€, depending on the symbol, symbol position, decimal place, and thousands-separator values that you set.
$123 or 123$ or 1,23, depending on the decimal places, separator, symbol, and symbol position that you specify.
6067 or 6067.5 or 6,067.45, depending on the decimal place and thousands-separator values that you set.
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.
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.
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.
How to apply a number format
1  
2  
*
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.
*
Choose OK.
Figure 2-23  

Additional Links:

Copyright Actuate Corporation 2012