To create a column that displays date values that are greater than the date values in another column, complete the following steps.
1 Select a column. From the context menu, choose Column→Choose New Computed Column. New Computed Column appears.
2 In Column Label, type a name for the calculated column. For example, type Forecast Shipping Date.
5 For the first argument, type a left bracket ([) and select the date column from the list. For example, select Order Date.
7 Validate the expression and choose OK. The calculated column appears in the report. For every value in the Order Date column, the calculated column displays a date seven days later than the order date.
|
|
Copyright Actuate Corporation 2012 |