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?"

"Discoverer calculation examples"

"How to create calculations"

"How to create a new calculation using an analytic function template"

List calculations for

Use this drop down list to specify which calculations you display 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 next to the calculation.

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

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.

Note: When you remove calculations, you also remove items that are dependent on the calculation (e.g. other calculations, conditions, sorts. For example, if the calculation that you delete is used in a worksheet parameter, the parameter is also removed.

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.