Setting calculation methods for indicators
Last updated
Last updated
The IP can set the appropriate calculation method for each indicator in a PD. If a partner selects a Ratio or Percent indicator, the calculation method will be set to SUM and greyed out. They cannot change the calculation method unless it is a Quantity Indicator.
The following calculation methods are supported:
Sum - simply adds data.
Avg - The average of the data.
Max - The maximum value in the period being looked at.
This represents how the IP would like to aggregate the data entered for all the locations in an indicator. Once applied this helps measure the total progress made on an indicator in a reporting period.
This represents how the IP would like to aggregate the data entered across various reporting periods. This is what decides what progress has been made on an indicator at any given point of time.
The calculation method in this case is applied to the total progress made on an indicator in a reporting period (not location level data at all).
Ratio indicators calculation method is different from quantity indicators. For ratio indicators, the system adds the numerators & denominators separately at the location level and then divides them at the end for indicator report total (#973).
It's possible to accept 0 for both numerator and denominator at the indicator location data entry time, indicating the data for corresponding disaggregations is no-progress. The 0/0 data entry will not affect calculations for subtotals and totals for the location.
If the location has all no-progress data entries, then the total and subtotals will be 0.
Calculation method is always latest for ratio indicator type. This calculation method is used to compute progress against the total for a indicator. This is done by simply grabbing indicator report total from the latest indicator report by the due date. (#973)
If the indicator has percentage display type, calculation methods across location and reporting periods are identical to the above sections. For percentage display type, the indicator report total value is multiplied by 100 so that the value is in percentage format. (#973)
When the IP user goes to set calculation methods, we will enable the user to be able to understand the impact their calculation method selection will have, by showing the user some example numbers / data for an example indicator.
When changing the calculation method and saving, we have a warning modal to that let's user know changing calculation methods will recalculate progress reports for their indicators (#875). We will send a notification email to UNICEF Focal point if the calculation method is changed for progress reports in PD that was previously submitted or accepted (#462)
