13-62
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 M anaging Reports
Organizing Report Data
Using Multiply Values in Calculated Columns
To use multiply values in calculated columns:
Step1 Select a column. In the report, the new calculated column appears to the right of the column you select.
Step2 Select Add Calculation.
The Calculation dialog box appears.
Step3 In the Column Label field, type a header for the calculated column.
The header must start with a letter and can contain only letters , numbers, underscores, and spaces.
Step4 In the Enter Expression field, type a left square bracket ([ ).
A list of the columns in the report appears. This list includes any calculated columns the report contains.
Step5 Select the column that contains the multiplier.
For example, to multiply a unit price times the quantity ordered, select the column that contains unit
prices.
Step6 Enter an asterisk (* ) as the multiplication operator. You do not need to include a space after the column
name.
Step7 Enter another left square bracket ([ ) and select the multiplicand.
For example, if the multiplier is the unit price, select the column that contains the quantity ordered as
the multiplicand.
Step8 To verify the expression, click Vali date.
If the expression syntax is correct, the dialog box displa ys a validation message.
If the expression syntax is incorrect, the dialog box displays a message explaining the error.
Step9 After validating the expression, click Apply.
The calculated column appears in the report, by usin g the column header you typed.
Adding Days to an Existing Date Value
You can create a column that displays date values that are greater than the date values in another column.
Step1 Select a column.
The calculated column appears to the right of the column yo u select.
Step2 Select Add Calculation.
The Calculation dialog box appears.
Step3 In Column Label, type a name for the calculated column. For example, type Forecast Shipping Date.
Step4 In Enter Expression, type the letter A.
A drop-down list appears, displaying functions that begin with A.
Step5 Select ADD_DAY(date, daysToAdd).
Step6 For the first argument, type a left opening bracket ( [ ) and select the date column from the drop-down
list. For example, select Order Date.