dhis2-users team mailing list archive

[Robin Martens <martens@xxxxxxx>]

Hi all,

I’ve got an issue with averaging over custom dimensions in indicator calculations.

Basically, my equation is: IND = A / B, with data elements A and B both having the same custom dimension. The aggregation operator for A is defined as a sum and for B as an average. Here is the raw data:


·        IND = CDE

·        A = ADE070

·        B = ADE078

[cid:image005.jpg@01D0616C.B49A55C0]

When generating an aggregated pivot table, it nicely shows the sum of A and the average of B, however, the value of IND does not take the average of B but the sum of B as an input and therefore is wrong.

[cid:image006.jpg@01D0616C.B49A55C0]

Anyone else encountered this issue? Is it a bug?

Regards,

Robin