How to add a computed field to a data set
In Edit Data Set, choose Computed Columns.
Choose New to create a new computed field.
On New Computed Column:
In Column Name, type a name for the computed field.
In Data Type, select a data type appropriate for the data returned by the computed field.
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.
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‑5 shows how to create an expression for a computed column.
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.
To see all the columns that are specified in the data set, choose Output Columns. The computed field you created appears on this page.
Choose Preview Results to confirm that the computed field returns the correct data.
Choose OK to save your changes to the data set.