Inconsistent indicator totals for indicators using Average (sum in organisationunit hierarchy)
Basic
Advanced
Basic
Advanced
Description
The 2.28 feature to average totals are resulting in inconsistent values calculated for years when comparing different periods - months vs quarters vs annual vs finyear.
The reports attached illustrates the problem. The main cause of this is two-fold:
1) The average used for months vs quarters are not calculating the same due to averaging percentages which is more than just a rounding issue but probably a mathematical issue. 2) The calculation for finyear is fundamentally incorrect when compared with quarters or months due to the fact that the Finyear uses a calendar year denominator vs the denominator for a last quarter for FinyrApr is the next calendar year value instead of the previous calendar year.
The 2nd issue is really problematic and reduces the reliability of DHIS2 reports drastically.
This was tested by the reporter Elmarie and received confirmation that test was passed
Jan Henrik Øverland March 7, 2019 at 10:41 AM
At the moment the second issue is just fixed in master. We want to test is properly before backporting, but that should happen in not too long.
Elmarie Claasen March 1, 2019 at 11:16 AM
can I ask does this include only the first problem or both?
Jan Henrik Øverland March 1, 2019 at 11:04 AM
This should now be properly backported to 2.30+ so please update to the latest.
2.29 will not get this as it would be an implementation rather than a backport.
Elmarie Claasen February 21, 2019 at 8:28 AM
Edited
Hi we have tested and agree that the totals show up correctly now for months, quarters and calendar year. Our testing was on a 2.30 version. To which versions are you able to back port this fix?
The 2.28 feature to average totals are resulting in inconsistent values calculated for years when comparing different periods - months vs quarters vs annual vs finyear.
The reports attached illustrates the problem. The main cause of this is two-fold:
1) The average used for months vs quarters are not calculating the same due to averaging percentages which is more than just a rounding issue but probably a mathematical issue.
2) The calculation for finyear is fundamentally incorrect when compared with quarters or months due to the fact that the Finyear uses a calendar year denominator vs the denominator for a last quarter for FinyrApr is the next calendar year value instead of the previous calendar year.
The 2nd issue is really problematic and reduces the reliability of DHIS2 reports drastically.
Related to DHIS2-5696