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 runtime:

  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

    Currency

    Percentage

    Scientific

    Custom

    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 (,).

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

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

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

    Enter your own custom format for the data.

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

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback