Sample Number Format Strings

This topic contains three tables:

  1. The first table illustrates the default number format strings that ship with CalcBuilder.

  2. 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.

  3. 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.

Default CalcBuilder number format strings

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%"

Sample strings for views and calculations

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
(See note below)

+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 "####").

Sample strings for calculations

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