This topic contains three tables:
The first table illustrates the default number format strings that ship with CalcBuilder.
The second table provides a list of sample number format strings that you can use when formatting numbers in views and calculations in BI Beans applications.
The third table provides a list of sample number format strings that you can use when formatting calculations in BI Beans applications.
Note: The quotation marks that appear in the tables will not appear in the output. The quotation marks are used here to make it clear where there are leading or trailing spaces.
The following table illustrates the sample number format strings that are used to format the numbers that are displayed in the Number Format dialog in the CalcBuilder.
Number Format String | Sample Number | Number Displayed |
---|---|---|
999999990 |
-9999.00 |
"-9999" |
999990D99 |
-9999.00 |
"-9999.00" |
999G990 |
-9999.00 |
"-9,999" |
999G990PR |
-9999.00 |
"<9,999>" |
(999G990) |
-9999.00 |
"(9,999)" |
999G990D99 |
-9999.00 |
"-9,999.00" |
(L999G990D99) |
-9999.00 |
"($9,999.00)" |
L999G990D99 |
-9999.00 |
"-$9,999.00" |
9990D99V99% |
-0.9999 |
"-99.99%" |
The following table illustrates sample number format strings for use when formatting numbers in views and calculations in BI Beans applications. These sample strings use the Oracle Number Format, which is described in the Oracle9i SQL Reference.
Number Format String | Sample Number | Number Displayed |
---|---|---|
9,999.00 |
+1234.1275 |
" 1,234.13" |
90.99 |
+0.1 |
" 0.10" |
90.99 |
0 |
" 0.00" |
90.99 |
-0.2 |
"-0.20" |
99.99 |
+0.1 |
" .10" |
99.99 |
0 |
" .00" |
99.99 |
-0.2 |
"-.20" |
999.009 |
+123.0 |
" 123.000" |
999.009 |
+123.45 |
" 123.450" |
999.009 |
+123.456 |
" 123.456" |
999.999 |
+123.456 |
" 123.456" |
999.999 |
+123456 |
" 123456.000" |
999.999 |
-123.456 |
"-123.456" |
9999 |
0 |
" 0" |
9999 |
1 |
" 1" |
9999,9999.99 |
+12345678.90 |
" 12345678.90" |
9999999999S |
+1234567890 |
"1234567890+" |
9999999999S |
-1234567890 |
"1234567890-" |
9999PR |
+1234 |
" 1234 " |
9999PR |
-1234 |
"<1234>" |
999D00MI |
+123456789.1234 |
"123456789.12 " |
999D00MI |
-123456789.1234 |
"1234567890.12-" |
9G999.00 |
+1234.1275 |
" 1,234.13" |
C999.99 |
-123.45 |
"-USD123.45" |
L99.99 |
+123.45 |
" $123.45" |
L999.99 |
+123.45 |
" $123.45" |
Note: Unlike the Oracle database, BI Beans does not truncate the displayed number if the number of specified digits is not sufficient (for example, it does not display "####").
The following table illustrates sample number format strings for use when formatting calculations in BI Beans applications. These sample strings use the BI Beans Number Format.
Number Format String | Sample Number | Number Displayed | Notes |
---|---|---|---|
($999.99) |
+123.45 |
" $123.45" |
None |
(999.999) |
+123456 |
" 123456.000 " |
None |
(999.999) |
-123.456 |
"(123.456)" |
None |
(9999) |
+1234 |
" 1234 " |
None |
(9999) |
-1234 |
"(1234)" |
None |
990D00% |
+71.4693 |
" 71.47%" |
Percentage that is not scaled |
990D00V99% |
+0.714693 |
" 71.47%" |
Percentage this is scaled up by factor of 2 [100:hundreds] |
9999D00V-99 |
+7934 |
" 79.34" |
Scale number down by factor of 2 [100:hundreds] |
9999D00VC-999 |
+7934 |
" 7.93K" |
Scale number down by factor of 3 [1000:thousands] |
9999V-99 |
+7934 |
" 79" |
Scale number down by factor of 2 [100:hundreds] |
9999VC-99 |
+7934 |
" 79" |
Scale number down by a factor of 2 [100:hundreds], but because a scaling factor is not defined for hundreds, the factor is not displayed. |
9999VC-999 |
+7934 |
" 8K" |
Scale number down by factor of 3 [1000:thousands] |
L[£]999.99 |
-123.45 |
"-£123.45" |
None |