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
