Oracle9iAS Discoverer Plus User's Guide Version 9.0.2 Part Number A90879-02 |
|
Use this dialog to change the way that the currently selected calculation item behaves. For example, to changes its name, description, or formula.
For more information, see:
"Oracle8i analytic function examples"
"Oracle9i analytic function examples"
Use this field to enter a descriptive name for the calculation item. This name is displayed in calculation lists and on worksheets as the column header of the calculation results column. If you leave this box blank, Discoverer creates a default name for you.
Use this drop down list to display calculations, functions, items and parameters that you can use to build your calculation. To include items in the calculation, add them to the calculation box on the right (see Notes below).
Use this button to add the item currently selected in the Show list into the Calculation box. The item is copied into the Calculation box at the right hand side.
Use this text box to enter the calculation details. To create a calculation, you can either:
Use these buttons to add operators to the calculation. Operators are copied into the Calculation box above.
Use this button to validate the calculation and save the item.
For example, the calculation Price - Discount * Quantity is evaluated as Discount*Quantity subtracted from Price. If you use parentheses around the subtraction expression (Price - Discount), the subtraction is executed before the multiplication.
|
Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|