A.3.3.3 Computing Columns

This option enables you to add computed columns to your report.

These can be mathematical computations (for example, NBR_HOURS/24) or standard Oracle functions applied to existing columns. Some display as examples and others (such as TO_DATE) can also be used).

To create the computation, follow these steps:

1. From the Actions menu, select Data, and then select Compute. The Compute page is displayed.
2. Select New Computation from the drop-down list.
3. Enter the name of the new column to be created in the Column Label field.
4. Select an Oracle format mask to be applied to the new column from the Format Mask drop-down list.
5. Select a column to add the Column Aliases in the computation expression.
6. Select a shortcut for commonly used keys in the Keypad.
7. Select the required Function / Operators.
   The following example computation demonstrates how to display total compensation:
   CASE WHEN A = 'SALES' THEN B + C ELSE B END
   (where A is ORGANIZATION, B is SALARY and C is COMMISSION)
8. Click Apply. The revised report appears with the new column.
   To delete the computation, follow these steps:
   • From the Actions menu, select Data, and then select Compute. The Compute page is displayed.
   • In the Computation drop-down list, select the previously created computation.
   • Click Delete. The selected computation is removed.