In Interactive Viewer, you can use the expression builder to enable the viewer to construct an expression for you, or you can construct a custom expression by selecting Advanced in the Category field. The expression you create is used to compute the new calculated column that appears in the report.
1 Select the column to the left of where you want to place the new computed column. From the context menu, choose Column→New Computed Column. New Computed Column appears.
2 In Column Label, type a name for the new computed column. The name you specify appears in the column header.
5 Based on the function you select, one or more column fields appears. In each Column field that appears, select a column from the list.Choose OK. The new computed column based on the expression you built, appears in the report.
To use a data field in the expression, type the left bracket ([), then select the required field from the list that appears. The list displays only fields in the report.
To use a function, type the first letter of the function, then select the function from the list that appears. The functions indicate the arguments, if any, that you need to specify.
2 After you complete typing the expression, choose Validate. If the expression is syntactically correct, Information appears informing you that the expression is valid, as shown in Figure 64.
Figure 64 Select the computed column. From the context menu, choose Column→Edit Computed Column. New Computed Column appears. To modify the expression, continue as described in the previous section.


Copyright Actuate Corporation 2012 