Previous Next JavaScript must be enabled to correctly display this content

## 3.6.7 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.
- Deleting a Computation
  Open the Compute dialog to remove a computation.

Parent topic: Customizing an Interactive Report Using the Actions Menu

### 3.6.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:

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.
   Description of the illustration ir_compute_eg.png

   The revised report appears with the new Available Budget column.

Parent topic: Computing Columns

### 3.6.7.2 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.

Parent topic: Computing Columns