46/78
3.7.7 Computing Columns
Add mathematical computations (for example, NBR_HOURS/24
) or standard Oracle functions to columns.
3.7.7.1 Creating a Computation
Use the Compute function in the Actions, Data submenu to add a computation to a column.
To create a computation:
- Click the Actions menu and select Data and then Compute.
The Compute dialog appears.
- In the Compute dialog:
- Computation - Select New Computation.
- Column Heading - Enter the name of the new column to be created.
- Format Mask - Select an Oracle format mask to be applied to the new column. (For example,
$5,234.10
).
- Create the computation:
- Columns - Select a column or alias.
- Keypad - Select a shortcut for commonly used keys.
- Functions - Select the appropriate function.
In the following example, a new column compares the actual cost to the budgeted amount, using the formula I - H
, where I
is the budgeted amount and H
is the cost.
- Click Apply.
The revised report appears containing a new Cost Analysis column.
3.7.7.2 Deleting a Computation
Open the Compute dialog to remove a computation.
To delete a computation:
- Click the Actions menu and select Data and then Compute.
The Compute dialog appears.
- From Computation, select the computation.
The computation appears.
- Click Delete.