Computing Columns

Add mathematical computations (for example, NBR_HOURS/24) or standard Oracle functions to columns.

Creating a Computation

Use the Compute function in the Actions, Data submenu to add a computation to a column.

To create a computation:

1. Click the Actions menu and select Data and then Compute.

   The Compute dialog appears.

2. In the Compute dialog:

   1. Computation - Select New Computation.

   2. Column Label - Enter the name of the new column to be created. For example, Available Budget.

   3. Format Mask - Select an Oracle format mask to be applied to the new column. For example, $5,234.10.

3. Create the computation:

   1. Column Aliases - Select a column to add the column alias in the computation expression.

   2. Keypad - Select a shortcut for commonly used keys.

   3. 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.

4. Click Apply.

   The revised report appears with the new Available Budget column.

   

   Description of the illustration ir_compute_eg.png

Deleting a Computation

Open the Compute dialog to remove a computation.

To delete a computation:

1. Click the Actions menu and select Data and then Compute.

   The Compute dialog appears.

2. From Computation, select the computation.

   The computation appears.

3. Click Delete.