I am getting a very strange result for program indicators. I have a tracker capture that tracks people across several program stages (infant feeding, Malaria, Hygiene, SRH/FP). Data clerks have registered 1334 people. In all stages, we have a data element: number of sessions attended, so the data clerk enters the number of sessions each person attended, which is six sessions maximum.
I have built a program to sum all the sessions people attended for infant feeding but I get very strange results
For the PI I have got the following:
Aggregation type: Count
Expression: infant feeding.number of sessions attended
Filter: Program Stage Name ==‘infant feeding’
I expected to get approximately 8004 as result, but I get a very large number as in the picture below. Why this strange result?