Formatting Numeric Data

You can format numeric data as currency, as a percentage, and so on or create your own custom format.

To format numeric data at run time:

1.   Right-click a field in the Values area of the C1OlapPanel.

2.   Click Field Settings in the context menu. The Field Settings dialog box opens.

3.   Click the Format tab.

4.   Select one of the following options:

Numeric

Formats the data as a number like this: 1,235. You can specify the number of decimal places and whether to use a 1000 separator (,).

Currency

Formats the data as currency. You can specify the number of decimal places.

Percentage

Formats the data as a percentage. You can specify the number of decimal places.

Scientific

Formats the data in scientific notation. You can specify the number of decimal places.

Custom

Enter your own custom format for the data.

 

5.   Click OK to close the Field Settings dialog box. Notice how the values in the summary table change.


ComponentOne Logo
Send comments about this topic to ComponentOne.
Copyright © GrapeCity, inc. All rights reserved.