## How to add a computed field to a data set

2 In Data Type, select a data type appropriate for the data returned by the computed field.

3 To perform a calculation on all the rows in the data set, in Aggregation, select an aggregate function. If performing an aggregate calculation, you can optionally specify a filter expression in Filter to determine which rows to include in the calculation.

4 In Expression, specify the expression to calculate the desired value. You can either type the expression or use the expression builder to construct the expression. To use the expression builder, complete the following steps:

o Choose the expression builder button to open the expression builder. In Category, select Available Data sets, then select your data set. Double-click an item to add it to the text area at the top. Figure 3-7 shows how to create an expression for a computed column.Figure 3-7Creating an expression for a computed column

o Choose OK to save the expression. The expression appears in the Expression field in New Computed Column.

5 Choose OK to save the computed field. Computed Columns displays the computed field and the expression you defined.

4 Choose Output Columns to see all the columns that are specified in the data set. The computed field appears on this page.

(c) Copyright Actuate Corporation 2011 |