Previous Next

Retrieving Data : About data sets : How to add a computed field to a data set

How to add a computed field to a data set

1
In Edit Data Set, choose Computed Columns.
2
3
1
In Column Name, type a name for the computed field.
2
3
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:

1
Choose the expression builder button to open the expression builder. In Category, select Available Data sets, then select your data set.
In the top pane, type an expression. You can also double-click an item to add it to the expression at the insertion point. Figure 3‑5 shows how to create an expression for a computed column.

Figure 3-5 Creating an expression for a computed column

Figure 3-5
2
4
Choose OK to save the computed field. Computed Columns displays the computed field and the expression you defined.
4
To see all the columns that are specified in the data set, choose Output Columns. The computed field you created appears on this page.
5
6
Choose OK to save your changes to the data set.

(c) Copyright Actuate Corporation 2008