Hello Dears ,
I have an ODK form with 37 diseases and the data collected based on ages / gender (Shown in the attached image )
I am trying to combine the data in the code based on gender by add them to each other like this :
(malaria.male.case.5.14.opd + malaria.male.case.15.45 + malaria.male.above.45 + injection_dressing.male.above.45+ injection_dressing.male.case.15.45+ injection_dressing.male.case.5.14.opd) as Opd.male ,
The total is not true .
I tried to separte each disease alone
(malaria.male.case.5.14.opd + malaria.male.case.15.45 + malaria.male.above.45 ) as malaria.male ,
( injection_dressing.male.above.45+ injection_dressing.male.case.15.45+ injection_dressing.male.case.5.14.opd) as injection_dressing.male ,
The result is correct for each of them but it's better to but them all together , because I will do the same to calculate the Females and to calculate the age disaggregation .
can anyone explain to me why this happen
