- In Column Name, type the name of the computed field.
- In Data Type, select a data type for the computed field.
- 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:
- 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-10 shows how to create an expression for a computed column.
Figure 3-10 Creating an expression for a computed column
- Choose OK to save the expression. The expression appears in the Expression field in New Computed Column.
- Choose OK to save the computed field. Computed Columns displays the computed field and the expression you defined.