Calculated Results Dialog Box
Use this dialog box to calculate and display extra results on reports without storing them in the database.
You can perform basic mathematical operations, such as multiplying a result by a value. For example, you can create a calculated result called Fee that multiplies the sum of various results by a value entered on the Calculated Results dialog box.
Calculated Results Pane
Field | Description |
---|---|
Result | This list displays the available calculated results for the selected project. |
Result Code | Cobra uses this field when reporting to identify specific results generically. Cobra reserves the following sort codes for special purposes:
|
Currency | Select this checkbox to include this result in the totals of the Project view, the Project Audit, and the report totals. This prevents different types of units, such as hours and dollars, from being added together. All results that are in the same currency as the currency defined on the General tab of the Project Properties dialog box are usually marked as a currency result. However, if the majority of your reports do not include a result such as
Fee, you do not have to mark that result as a currency result. To report on
Fee, you can create a calculated result that has the currency flag. IPMR Format 3 reports include values found in the Project Audit log. To exclude
Fee from the body of the IPMR Format 3 report, you must not mark
Fee as a currency result.
You can perform the following actions:
|
Results Pane
This pane displays all of the results in the grid. This pane is not enabled until you have added a result on the Calculated Results pane. After adding the result, you must select the result to be used in the Results pane.
Field | Description |
---|---|
Result | This column displays the valid results available for the selected project. |
Field Name | This column identifies the actual field name for the result. |
Add | Click this button to add a result to the Expression pane. You can also add a field to the Expression pane by double-clicking the field. |
Expression Pane
This pane displays the expression used for defining a calculated result. You can combine results to form the definition of the calculated result using any of the following operators:
- Add (+)
- Subtract (-)
- Multiply (*)
- Divide (/)
- Group (( ))
Mathematical operators are evaluated according to the normal rules of precedence:
- Cobra performs grouping operations before multiplication and division operations.
- Cobra performs multiplication and division operations before addition and subtraction operations.
An error message displays if you enter an invalid expression.