Oracle Application Server Discoverer Plus User's Guide 10g (9.0.4) Part Number B10268-01 |
|
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 a calculation. To include items in the calculation, paste them into the Calculation field.
Use the Show list options as follows:
Use this button to the add the item currently selected in the Show list to the Calculation. The item is copied into the Calculation field.
Use this field to enter the calculation details (for calculation examples, see "Discoverer calculation examples").
To create a calculation, you one or more of the following methods:
Note: If you type an expression in the Calculation field, you must prefix the expression with an equals sign (i.e. =). For example, '=Sales SUM-Costs SUM'.
Use this button to display a pop-up list of templates that you can use to build analytic functions. For example, choose Rank to display an easy-to-use Rank template that helps you create a league table position calculation. For more information about templates available, see "What analytic function templates are available in Discoverer".
Use these buttons to add operators to the calculation. Operators are copied into the Calculation field.
Note: When you use arithmetic expressions in a calculation, the multiply and divide operators are executed first, regardless of their position in the calculation. If you have more than one operator of the same precedence, they are evaluated from left to right.
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.
Use this button to validate and save the calculation, as follows:
|
![]() Copyright © 1999, 2003 Oracle Corporation. All Rights Reserved. |
|