Skip Headers
Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)

Part Number B32519-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

Edit Calculation dialog

Use this dialog to edit items and calculated items.

For more information, see:

"What are items?"

"What are calculated items?"

"How to edit calculated items"

For example:


Use these options to display calculations, functions, and item that you can use to build a calculation. To include items in the calculation, paste them into the Calculation field.


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 at the position of the cursor.


Use this field to edit the name of the item or calculated item.


Use this field to enter the calculation details (for calculation examples, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus).

To create a calculation, you one or more of the following methods:

Operator buttons + - x / % ( )

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: