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:

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

To format numeric data in code:

Use the Format property of the field and Microsoft standard numeric format strings to specify the format.

Accepted format strings include:

In this example code, first the view is created, and then the average unit price is calculated in currency format.

            // build view

            var olap = this.c1OlapPage1.OlapEngine;

            olap.ValueFields.Add("UnitPrice");

            olap.RowFields.Add("OrderDate", "ProductName");

            // format unit price and calculate average

            var field = olap.Fields["UnitPrice"];

            field.Subtotal = Subtotal.Average;

            field.Format = "c";