Edit Worksheet dialog: Calculations tab

Use this tab to specify calculations on the current worksheet. This tab displays a list of existing calculations available to the worksheet. Use this tab to:

• display and hide existing worksheet calculations

• manage existing calculations

• create new calculations

For more information, see:

"What are calculations?"

"Simple calculation examples"

"Oracle8i analytic function examples"

"Oracle9i analytic function examples"

View calculations for

Use this list to limit the calculations that are displayed in the list below. The default setting displays calculations for all items, which lists all calculations available to the current worksheet.

• To display a calculation in the current worksheet, select the check box beside the calculation that you want to display.

• To hide a calculation, clear the check box next to the calculation that you want to hide.

Description

This field displays the formula of the currently selected calculation.

New

Use this button to display the New Calculation dialog (see "New Calculation dialog"). Use the New Calculation dialog to create new calculations.

Edit

Use this button to display the Edit Calculation dialog (see "Edit Calculation dialog"). Use the Edit Calculation dialog to edit the currently selected calculation.

Delete

Use this button to permanently remove the selected calculation.

Options

Use this button to display the Options dialog. Use the Options dialog to specify:

• how Discoverer handles queries (see "Options dialog: Query Governor tab")

• how Discoverer formats worksheets (see "Options dialog: Sheet Format tabs")

Notes

• To remove a calculation from a worksheet without deleting the calculation, hide the calculation using the View calculations for drop down list.

• You are not allowed to delete calculations created for you by the Discoverer manager.