I have created a program indicator to measure the number of people (V{tei_count}) who have received at least one service (recorded as a series of data elements). A simplified version of the filter is:
(data element PMTCT== 1) ||(data element PEP== 1) ||(data element PREP== 1)
This works.
However, i now want to have the same indicator, but for it to only count the number of females reached with at least one of these services. This uses an Option (female) in the Option Set (gender) used in Attributes when the person is enrolled. I’ve used the following filter:
(data element PMTCT== 1) ||(data element PEP== 1) ||(data element PREP== 1) && Gender == ‘female’
However this does not return the correct result. It does have a green tick to say the syntax is correct, but when i run the report, it is returning the same result as before i disaggregated it (so if the total for the previous programme indicator is 100, when disaggregated by gender it returns 100 for both male and 100 for female which clearly isn’t right). I’ve checked the correct option set and option code has been used. Any suggestions of what i’ve done wrong?
thank you!