Indicator formula with AOC but no COC

Implementation - Implémentation
1

Hi Community,

I would like to find out if it is possible to have an indicator formula with {DEUID. .AOCUID} and not use any COC UID.
My use case is as follows. I have a Data Element with COC for Key and Vulnerable Populations (KVP) and the attributes captured are for Age and Gender.
I want to create an indicator that calculates the proportion of DE by KVP out of the total DE value and I want to be able to filter on Age and Gender attribute when creating the report.
So the Numerator is {DEUID.COCUID1.AOCUID1} + DEUID.COCUID2.AOCUID1} etc. but for the denominator I only want the total for the KVP included. How do I do this? I have not seen using a wildcard like * in the formula and do not know if that exists if it would really utilise the total KVP value?

ART initiation percentage by Key Vulnerable Population = Initiated on ART by KVP & Age and Gender / Initiated on ART by Age and Gender (with total KVP)

2

I am not sure that it is supported. Even though it is not perhaps effecient as possible, I am still not sure why you cannot use all of the COCs which “*” would represent. Would this not be the same outcome?

3

Hi @jason
I also thought that I could use ‘*’ but it is not supported or a bug as any formula with a ‘*’ for COC or AOC is invalid so unable to save the formula.
@Karoline, I am not sure if this is a bug and whether there is already a bug reported. Could you clarify?

In fact I have now discovered that any indicator with an AOC in the formula does not calculate at all. Do we know f this is another bug? I’m using 2.42.3

4

I suspect that this is a bug, I also can’t create indicators with AOC so I’m going to ask @Jim_Grace because according to previous posts this became supported in later versions.

5

I can start looking at this tomorrow …

6

As far as I can tell, this works as expected. In an indicator expression, you can specify the following for a data element:

#{deuid.*.aocuid}

This returns the value for the given data element within the given Attribute Option Combination, summed across all Category Option Combinations.

1 Like