Use the Calculated Results feature 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:
- <NONE> — No result code
- C (Cost of Money) — This sort code instructs Cobra that the result is
Cost of Money.
- D (Direct) — This sort code instructs Cobra that the result is
Direct.
- Fee — This sort code instructs Cobra that the result is
Fee.
- F (Full Time Equivalent) — This sort code instructs Cobra that the result is
Full Time Equivalents.
- G (General and Administrative) — This sort code instructs Cobra that the result is
General and Administration and needs to be dropped to the bottom line of CPR reports.
- H (Hours) — This sort code Identifies the result as a unit measured in
Hours.
- N ( No Scale Factor) — This sort code instructs Cobra not to divide the value by a scale factor.
- O (Overhead) — This sort code instructs Cobra that the result is
Overhead and needs to be dropped to the bottom line of ICSR reports.
|
Currency
|
Select this check box 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. CPR Format 3 reports include values found in the Project Audit log. To exclude
Fee from the body of the CPR Format 3 report, you must not mark
Fee as a currency result.
You can perform the following actions:
- Add — Click this button to add a new calculated result.
Attention: For more information, see the help for the Add Calculated Result Dialog Box of the Calculated Results Wizard.
- Copy — Select a calculated result you want to copy then click the
Copy button. An error occurs when you try to copy a calculated result that has been modified or added without being saved.
Attention: For more information, see the help for the Copy Calculated Result Dialog Box of the Calculated Results Wizard.
- Delete — Select a result you want to delete then click the
Delete button. A confirmation message displays. Click
Yes to proceed with the deletion.
|
Delete
|
Select a result you want to delete then click the
Delete button. A confirmation message displays. Click
Yes to proceed with the deletion.
|
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.