...
The source Project Indicator must be a currency, number or percent indicator.
...
Select the relevant value from the “Type of Result” picklist field. You can use a Project Indicator where results are manually input or another Calculated or Aggregated Project Indicator.
...
Once the Calculation Formula popup opens, the user can either create a formula immediately or select “Cancel”. Selecting “Cancel” will save the Project Indicator with no calculation formula, allowing the user to return and set the formula at a later time.
In the Calculation Formula popup, use the “Select Indicator”picklist to select the first source Project Indicator. Only active Project Indicators with the same geographic level, reporting frequency and disaggregation level are shown in the picklist.
Use the Select an Operationpicklist to select the desired operation.
| Info |
|---|
When creating a calculated Project Indicator that involves division in the formula, ensure that the “Number of Decimal Points Allowed” field for that Project Indicator has been set to either 1 or 2. |
...
An incomplete formula - for example, “Number of lamps +” will not be saved. If the user tries to save an incomplete formula, an error message will appear in response to the formula that is not mathematically possible. We recommend avoiding illogical formulas to ensure accurate results.
After clicking “Save and Exit” popup, a banner will display and confirm the successful creation of the calculated indicator. The new Project Indicator will appear in the “Selected Indicators”table on the Manage Indicators page. If a user clicks on the “X” in the right-hand corner of the popup, or selects “Cancel”, before saving then the popup will close and the indicator will save with no formula entered.
...
In order to edit the Calculation Formula, click on “Save and Edit Calculation”
This will open the “Customize Calculation” popup where the source indicators or operators can be edited.
<Confirm with PG Should we put a note about not editing calculation formula after result records have been generated to avoid data inconsistencies?>Once a Project Indicator is deactivated, it cannot be used in the formula for a calculated Project Indicator. The calculation formula popup will not display the deactivated source Project Indicator when the user clicks into the search bar to create the formula. If the user types a deactivated Project Indicator in the search bar, the message “No matching records found” will display in the dropdown.
...