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)