Generated Narrative: Questionnaire espen-mda-treatment Tag: ESPEN (Details: ICR Project Tag code espen = 'ESPEN') Structure LinkID Text Cardinality Type Flags Description & Constraints EspenMDATreatment ESPEN MDA demo Form 3 (the treatment tally): village census plus per-drug treated counts by sex and age band with reasons-not-treated. Template-based extraction: one ICRDeliveryUnit community Group for the village, one Group-subject ICRMedicationAdministration per answered drug block (the treatment event — tablets into people are treatment, not a supply transfer), and one ICRAdministrativeCoverage MeasureReport per answered drug block — measure icr-mda-treatment-coverage, stratified by sex, age-band, and disposition, the same cube as example-mda-treatment-tally (espen-forms, remapped espen-remap). Questionnaire https://icr.healthcampaigns.org/Questionnaire/espen-mda-treatment#0.1.0 #xD; p_recorder_id Select the recorder ID 0..1 string #xD; p_state Select State / Region / Province 1..1 string #xD; p_district Select District / LGA / County 1..1 string #xD; p_health_facility Select the Health facility / Sub district 1..1 string #xD; p_location Enter the village / location / site 1..1 string #xD; p_location_id Enter the ID of village / location / site 1..1 string #xD; p_campaign_day Day of the campaign 1..1 choice Options: 10 options #xD; p_disease Disease covered by the TDM? 1..* choice Value Set: ICR NTD Disease #xD; p_medicine Select the medicine package 1..* choice Value Set: ICR MDA Medicine Package #xD; census Population census 0..1 group #xD; census_method Cencus method 1..1 choice Options: 2 options #xD; census_house_hold Number of households 0..1 integer #xD; census_men Number of men 0..1 integer #xD; census_women Number of women 0..1 integer #xD; dec_by_sex DEC By sex 0..1 group Enable When: p_medicine = IVM + ALB + DEC (ICR MDA Medicine Package#ivm-alb-dec) #xD; dec_5_14_female_treated 5-14 years old treated Female 1..1 integer #xD; dec_5_14_male_treated 5-14 years old treated Male 1..1 integer #xD; dec_15_female_treated 15 years and over treated Female 1..1 integer #xD; dec_15_male_treated 15 years and over treated Male 1..1 integer #xD; dec_men_treated Men treated 0..1 integer #xD; dec_women_treated Women treated 0..1 integer #xD; dec_reason_not_treated Reasons not treated with DEC 0..1 group Enable When: p_medicine = IVM + ALB + DEC (ICR MDA Medicine Package#ivm-alb-dec) #xD; dec_child Children <90 cm untreated 1..1 integer #xD; dec_pregnant Pregnant women untreated 1..1 integer #xD; dec_breastfeeding Breastfeeding women untreated 1..1 integer #xD; dec_absent Absent 1..1 integer #xD; dec_refusal Refusal 1..1 integer #xD; alb_by_sex ALB By sex 0..1 group Enable When: p_medicine = IVM + ALB + DEC (ICR MDA Medicine Package#ivm-alb-dec) p_medicine = IVM + ALB (ICR MDA Medicine Package#ivm-alb) p_medicine = ALB (albendazole) (ICR MDA Medicine Package#alb) p_medicine = PZQ + ALB (ICR MDA Medicine Package#pzq-alb) #xD; alb_5_14_female_treated 5-14 years old treated Female 1..1 integer #xD; alb_5_14_male_treated 5-14 years old treated Male 1..1 integer #xD; alb_15_female_treated 15 years and over treated Female 1..1 integer #xD; alb_15_male_treated 15 years and over treated Male 1..1 integer #xD; alb_men_treated Men treated 0..1 integer #xD; alb_women_treated Women treated 0..1 integer #xD; alb_reason_not_treated Reasons not treated with ALB 0..1 group Enable When: p_medicine = IVM + ALB + DEC (ICR MDA Medicine Package#ivm-alb-dec) p_medicine = IVM + ALB (ICR MDA Medicine Package#ivm-alb) p_medicine = ALB (albendazole) (ICR MDA Medicine Package#alb) p_medicine = PZQ + ALB (ICR MDA Medicine Package#pzq-alb) #xD; alb_child Children <90 cm untreated 1..1 integer #xD; alb_pregnant Pregnant women untreated 1..1 integer #xD; alb_breastfeeding Breastfeeding women untreated 1..1 integer #xD; alb_absent Absent 1..1 integer #xD; alb_refusal Refusal 1..1 integer #xD; meb_by_sex MBD By sex 0..1 group Enable When: p_medicine = PZQ + MEB (ICR MDA Medicine Package#pzq-meb) p_medicine = MEB (mebendazole) (ICR MDA Medicine Package#meb) #xD; meb_5_14_female_treated 5-14 years old treated Female 1..1 integer #xD; meb_5_14_male_treated 5-14 years old treated Male 1..1 integer #xD; meb_15_female_treated 15 years and over treated Female 1..1 integer #xD; meb_15_male_treated 15 years and over treated Male 1..1 integer #xD; meb_men_treated Men treated 0..1 integer #xD; meb_women_treated Women treated 0..1 integer #xD; meb_reason_not_treated Reasons not treated with MEB 0..1 group Enable When: p_medicine = PZQ + MEB (ICR MDA Medicine Package#pzq-meb) p_medicine = MEB (mebendazole) (ICR MDA Medicine Package#meb) #xD; meb_child Children <90 cm untreated 1..1 integer #xD; meb_pregnant Pregnant women untreated 1..1 integer #xD; meb_breastfeeding Breastfeeding women untreated 1..1 integer #xD; meb_absent Absent 1..1 integer #xD; meb_refusal Refusal 1..1 integer #xD; ivm_by_sex IVM By sex 0..1 group Enable When: p_medicine = IVM (ivermectin) (ICR MDA Medicine Package#ivm) p_medicine = IVM + ALB + DEC (ICR MDA Medicine Package#ivm-alb-dec) p_medicine = IVM + ALB (ICR MDA Medicine Package#ivm-alb) #xD; ivm_5_14_female_treated 5-14 years old treated Female 1..1 integer #xD; ivm_5_14_male_treated 5-14 years old treated Male 1..1 integer #xD; ivm_15_female_treated 15 years and over treated Female 1..1 integer #xD; ivm_15_male_treated 15 years and over treated Male 1..1 integer #xD; ivm_men_treated Men treated 0..1 integer #xD; ivm_women_treated Women treated 0..1 integer #xD; ivm_reason_not_treated Reasons not treated with IVM 0..1 group Enable When: p_medicine = IVM (ivermectin) (ICR MDA Medicine Package#ivm) p_medicine = IVM + ALB + DEC (ICR MDA Medicine Package#ivm-alb-dec) p_medicine = IVM + ALB (ICR MDA Medicine Package#ivm-alb) #xD; ivm_child Children <90 cm untreated 1..1 integer #xD; ivm_pregnant Pregnant women untreated 1..1 integer #xD; ivm_breastfeeding Breastfeeding women untreated 1..1 integer #xD; ivm_absent Absent 1..1 integer #xD; ivm_refusal Refusal 1..1 integer #xD; pzq_by_sex PZQ By sex 0..1 group Enable When: p_medicine = PZQ (praziquantel) (ICR MDA Medicine Package#pzq) p_medicine = PZQ + ALB (ICR MDA Medicine Package#pzq-alb) #xD; pzq_5_14_female_treated 5-14 years old treated Female 1..1 integer #xD; pzq_5_14_male_treated 5-14 years old treated Male 1..1 integer #xD; pzq_15_female_treated 15 years and over treated Female 1..1 integer #xD; pzq_15_male_treated 15 years and over treated Male 1..1 integer #xD; pzq_men_treated Men treated 0..1 integer #xD; pzq_women_treated Women treated 0..1 integer #xD; pzq_reason_not_treated Reasons not treated with PZQ 0..1 group Enable When: p_medicine = PZQ (praziquantel) (ICR MDA Medicine Package#pzq) p_medicine = PZQ + ALB (ICR MDA Medicine Package#pzq-alb) #xD; pzq_child Children <90 cm untreated 1..1 integer #xD; pzq_pregnant Pregnant women untreated 1..1 integer #xD; pzq_breastfeeding Breastfeeding women untreated 1..1 integer #xD; pzq_absent Absent 1..1 integer #xD; pzq_refusal Refusal 1..1 integer #xD; azm_susp_by_sex AZM Report Suspension by sex 0..1 group Enable When: p_medicine = AZM suspension (azithromycin) (ICR MDA Medicine Package#azm-susp) #xD; azm_susp_less7_boy_treated Boys from 6 months to less than 7 years treated 1..1 integer #xD; azm_susp_less7_girl_treated Girls from 6 months to less than 7 years treated 1..1 integer #xD; azm_susp_reason_not_treated Reasons not treated with AZM Suspension 0..1 group Enable When: p_medicine = AZM suspension (azithromycin) (ICR MDA Medicine Package#azm-susp) #xD; azm_susp_child Children <90 cm untreated 1..1 integer #xD; azm_susp_absent Absent 1..1 integer #xD; azm_susp_refusal Refusal 1..1 integer #xD; azm_tb_by_sex AZM Report Tablet by sex 0..1 group Enable When: p_medicine = AZM tablets (azithromycin) (ICR MDA Medicine Package#azm-tab) #xD; azm_tb_more7_boy_treated Boys more than 7 years treated 1..1 integer #xD; azm_tb_more7_girl_treated Girls more than 7 years treated 1..1 integer #xD; azm_tb_child Children <90 cm untreated 1..1 integer #xD; azm_tb_reason_not_treated Reasons not treated with AZM Tablet 0..1 group Enable When: p_medicine = AZM tablets (azithromycin) (ICR MDA Medicine Package#azm-tab) #xD; azm_tb_pregnant Pregnant women untreated 1..1 integer #xD; azm_tb_breastfeeding Breastfeeding women untreated 1..1 integer #xD; azm_tb_absent Absent 1..1 integer #xD; azm_tb_refusal Refusal 1..1 integer #xD; tetra_by_sex TETRA By sex 0..1 group Enable When: p_medicine = TETRA (tetracycline eye ointment) (ICR MDA Medicine Package#tetra) #xD; tetra_baby_boy Baby boy less than six month 1..1 integer #xD; tetra_baby_girl Baby girl less than six month 1..1 integer #xD; tetra_pregnant_women Pregnant Women 1..1 integer #xD; tetra_reason_not_treated reasons not treated with TETRA 0..1 group Enable When: p_medicine = TETRA (tetracycline eye ointment) (ICR MDA Medicine Package#tetra) #xD; tetra_child Children <90 cm untreated 1..1 integer #xD; tetra_pregnant Pregnant women untreated 1..1 integer #xD; tetra_breastfeeding Breastfeeding women untreated 1..1 integer #xD; tetra_absent Absent 1..1 integer #xD; tetra_refusal Refusal 1..1 integer #xD; cd_who_distributed CD who distributed during this year 0..1 group #xD; cd_who_distributed_man Community DistributorMen 1..1 integer #xD; cd_who_distributed_woman Community Distributor Women 1..1 integer #xD; cd_trained CD newly trained 1..1 integer #xD; cd_recycled CD Recycled 1..1 integer #xD; p_add_note Additional Note 0..1 text #xD; Documentation for this format Options Sets Answer options for p_campaign_day Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 Answer options for census_method Household-Level Digitization Aggregate Reporting Contained Resources MeasureReport #mr-dec Profile: ICR Administrative Coverage Coverage Source: administrative Real-time vs Reconciled: realtime status: Complete type: Summary measure: ICR MDA Treatment Coverage reporter: recorder period: 2026-01-01 --> 2026-01-01 group code: diethylcarbamazine population code: Numerator count: 0 population code: Denominator count: 0 stratifier code: Sex stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Age band stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Disposition stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 MeasureReport #mr-alb Profile: ICR Administrative Coverage Coverage Source: administrative Real-time vs Reconciled: realtime status: Complete type: Summary measure: ICR MDA Treatment Coverage reporter: recorder period: 2026-01-01 --> 2026-01-01 group code: albendazole population code: Numerator count: 0 population code: Denominator count: 0 stratifier code: Sex stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Age band stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Disposition stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 MeasureReport #mr-meb Profile: ICR Administrative Coverage Coverage Source: administrative Real-time vs Reconciled: realtime status: Complete type: Summary measure: ICR MDA Treatment Coverage reporter: recorder period: 2026-01-01 --> 2026-01-01 group code: mebendazole population code: Numerator count: 0 population code: Denominator count: 0 stratifier code: Sex stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Age band stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Disposition stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 MeasureReport #mr-ivm Profile: ICR Administrative Coverage Coverage Source: administrative Real-time vs Reconciled: realtime status: Complete type: Summary measure: ICR MDA Treatment Coverage reporter: recorder period: 2026-01-01 --> 2026-01-01 group code: ivermectin population code: Numerator count: 0 population code: Denominator count: 0 stratifier code: Sex stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Age band stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Disposition stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 MeasureReport #mr-pzq Profile: ICR Administrative Coverage Coverage Source: administrative Real-time vs Reconciled: realtime status: Complete type: Summary measure: ICR MDA Treatment Coverage reporter: recorder period: 2026-01-01 --> 2026-01-01 group code: praziquantel population code: Numerator count: 0 population code: Denominator count: 0 stratifier code: Sex stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Age band stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Disposition stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 MeasureReport #mr-azm-susp Profile: ICR Administrative Coverage Coverage Source: administrative Real-time vs Reconciled: realtime status: Complete type: Summary measure: ICR MDA Treatment Coverage reporter: recorder period: 2026-01-01 --> 2026-01-01 group code: azithromycin (suspension) population code: Numerator count: 0 population code: Denominator count: 0 stratifier code: Sex stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Age band stratum Populations - Code Count * Numerator 0 stratifier code: Disposition stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 MeasureReport #mr-azm-tb Profile: ICR Administrative Coverage Coverage Source: administrative Real-time vs Reconciled: realtime status: Complete type: Summary measure: ICR MDA Treatment Coverage reporter: recorder period: 2026-01-01 --> 2026-01-01 group code: azithromycin (tablets) population code: Numerator count: 0 population code: Denominator count: 0 stratifier code: Sex stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Age band stratum Populations - Code Count * Numerator 0 stratifier code: Disposition stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 MeasureReport #mr-tetra Profile: ICR Administrative Coverage Coverage Source: administrative Real-time vs Reconciled: realtime status: Complete type: Summary measure: ICR MDA Treatment Coverage reporter: recorder period: 2026-01-01 --> 2026-01-01 group code: tetracycline (eye ointment) population code: Numerator count: 0 population code: Denominator count: 0 stratifier code: Sex stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratifier code: Age band stratum Populations - Code Count * Numerator 0 stratifier code: Disposition stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 stratum Populations - Code Count * Numerator 0 Group #community-template Profile: ICR Delivery Unit (Household / Community / School Cohort) Group Location: Identifier: https://icr.healthcampaigns.org/identifier/espen-location-id/?ngen-9? identifier: https://icr.healthcampaigns.org/identifier/espen-community/?ngen-9? type: Person code: Community name: Extract Template - Extract value: %resource.repeat(item).where(linkId='p_location').answer.value.first() & ' community' quantity: 0 MedicationAdministration #ma-dec Profile: ICR Medication Administration Record Origin: campaign status: Completed subject: ?rref? MedicationAdministration #ma-alb Profile: ICR Medication Administration Record Origin: campaign status: Completed subject: ?rref? MedicationAdministration #ma-meb Profile: ICR Medication Administration Record Origin: campaign status: Completed subject: ?rref? MedicationAdministration #ma-ivm Profile: ICR Medication Administration Record Origin: campaign status: Completed subject: ?rref? MedicationAdministration #ma-pzq Profile: ICR Medication Administration Record Origin: campaign status: Completed subject: ?rref? MedicationAdministration #ma-azm-susp Profile: ICR Medication Administration Record Origin: campaign status: Completed subject: ?rref? MedicationAdministration #ma-azm-tb Profile: ICR Medication Administration Record Origin: campaign status: Completed subject: ?rref? MedicationAdministration #ma-tetra Profile: ICR Medication Administration Record Origin: campaign status: Completed subject: ?rref?
iif(%resource.repeat(item).where(linkId='dec_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)
iif((iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)) > 0, (iif(%resource.repeat(item).where(linkId='dec_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_15_male_treated').answer.value.first(), 0)) * 100 / (iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)), 0)
iif(%resource.repeat(item).where(linkId='dec_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_15_female_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='dec_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='dec_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_5_14_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='dec_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='dec_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='dec_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='dec_child').answer.exists(), %resource.repeat(item).where(linkId='dec_child').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='dec_pregnant').answer.exists(), %resource.repeat(item).where(linkId='dec_pregnant').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='dec_breastfeeding').answer.exists(), %resource.repeat(item).where(linkId='dec_breastfeeding').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='dec_absent').answer.exists(), %resource.repeat(item).where(linkId='dec_absent').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='dec_refusal').answer.exists(), %resource.repeat(item).where(linkId='dec_refusal').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_15_male_treated').answer.value.first(), 0)
iif((iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)) > 0, (iif(%resource.repeat(item).where(linkId='alb_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_15_male_treated').answer.value.first(), 0)) * 100 / (iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)), 0)
iif(%resource.repeat(item).where(linkId='alb_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_15_female_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_5_14_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='alb_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='alb_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_child').answer.exists(), %resource.repeat(item).where(linkId='alb_child').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_pregnant').answer.exists(), %resource.repeat(item).where(linkId='alb_pregnant').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_breastfeeding').answer.exists(), %resource.repeat(item).where(linkId='alb_breastfeeding').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_absent').answer.exists(), %resource.repeat(item).where(linkId='alb_absent').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='alb_refusal').answer.exists(), %resource.repeat(item).where(linkId='alb_refusal').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_15_male_treated').answer.value.first(), 0)
iif((iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)) > 0, (iif(%resource.repeat(item).where(linkId='meb_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_15_male_treated').answer.value.first(), 0)) * 100 / (iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)), 0)
iif(%resource.repeat(item).where(linkId='meb_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_15_female_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_5_14_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='meb_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='meb_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_child').answer.exists(), %resource.repeat(item).where(linkId='meb_child').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_pregnant').answer.exists(), %resource.repeat(item).where(linkId='meb_pregnant').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_breastfeeding').answer.exists(), %resource.repeat(item).where(linkId='meb_breastfeeding').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_absent').answer.exists(), %resource.repeat(item).where(linkId='meb_absent').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='meb_refusal').answer.exists(), %resource.repeat(item).where(linkId='meb_refusal').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_15_male_treated').answer.value.first(), 0)
iif((iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)) > 0, (iif(%resource.repeat(item).where(linkId='ivm_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_15_male_treated').answer.value.first(), 0)) * 100 / (iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)), 0)
iif(%resource.repeat(item).where(linkId='ivm_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_15_female_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_5_14_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='ivm_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='ivm_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_child').answer.exists(), %resource.repeat(item).where(linkId='ivm_child').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_pregnant').answer.exists(), %resource.repeat(item).where(linkId='ivm_pregnant').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_breastfeeding').answer.exists(), %resource.repeat(item).where(linkId='ivm_breastfeeding').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_absent').answer.exists(), %resource.repeat(item).where(linkId='ivm_absent').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='ivm_refusal').answer.exists(), %resource.repeat(item).where(linkId='ivm_refusal').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_15_male_treated').answer.value.first(), 0)
iif((iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)) > 0, (iif(%resource.repeat(item).where(linkId='pzq_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_15_male_treated').answer.value.first(), 0)) * 100 / (iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)), 0)
iif(%resource.repeat(item).where(linkId='pzq_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_15_female_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_5_14_male_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_5_14_female_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_5_14_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_5_14_male_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_5_14_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_15_female_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_15_female_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='pzq_15_male_treated').answer.exists(), %resource.repeat(item).where(linkId='pzq_15_male_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_child').answer.exists(), %resource.repeat(item).where(linkId='pzq_child').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_pregnant').answer.exists(), %resource.repeat(item).where(linkId='pzq_pregnant').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_breastfeeding').answer.exists(), %resource.repeat(item).where(linkId='pzq_breastfeeding').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_absent').answer.exists(), %resource.repeat(item).where(linkId='pzq_absent').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='pzq_refusal').answer.exists(), %resource.repeat(item).where(linkId='pzq_refusal').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_susp_less7_boy_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_less7_boy_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='azm_susp_less7_girl_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_less7_girl_treated').answer.value.first(), 0)
iif((iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)) > 0, (iif(%resource.repeat(item).where(linkId='azm_susp_less7_boy_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_less7_boy_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='azm_susp_less7_girl_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_less7_girl_treated').answer.value.first(), 0)) * 100 / (iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)), 0)
iif(%resource.repeat(item).where(linkId='azm_susp_less7_girl_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_less7_girl_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_susp_less7_boy_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_less7_boy_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_susp_child').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_child').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_susp_absent').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_absent').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_susp_refusal').answer.exists(), %resource.repeat(item).where(linkId='azm_susp_refusal').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_tb_more7_boy_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_more7_boy_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='azm_tb_more7_girl_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_more7_girl_treated').answer.value.first(), 0)
iif((iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)) > 0, (iif(%resource.repeat(item).where(linkId='azm_tb_more7_boy_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_more7_boy_treated').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='azm_tb_more7_girl_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_more7_girl_treated').answer.value.first(), 0)) * 100 / (iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)), 0)
iif(%resource.repeat(item).where(linkId='azm_tb_more7_girl_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_more7_girl_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_tb_more7_boy_treated').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_more7_boy_treated').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_tb_child').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_child').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_tb_pregnant').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_pregnant').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_tb_breastfeeding').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_breastfeeding').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_tb_absent').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_absent').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='azm_tb_refusal').answer.exists(), %resource.repeat(item).where(linkId='azm_tb_refusal').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='tetra_baby_boy').answer.exists(), %resource.repeat(item).where(linkId='tetra_baby_boy').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='tetra_baby_girl').answer.exists(), %resource.repeat(item).where(linkId='tetra_baby_girl').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='tetra_pregnant_women').answer.exists(), %resource.repeat(item).where(linkId='tetra_pregnant_women').answer.value.first(), 0)
iif((iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)) > 0, (iif(%resource.repeat(item).where(linkId='tetra_baby_boy').answer.exists(), %resource.repeat(item).where(linkId='tetra_baby_boy').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='tetra_baby_girl').answer.exists(), %resource.repeat(item).where(linkId='tetra_baby_girl').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='tetra_pregnant_women').answer.exists(), %resource.repeat(item).where(linkId='tetra_pregnant_women').answer.value.first(), 0)) * 100 / (iif(%resource.repeat(item).where(linkId='census_men').answer.exists(), %resource.repeat(item).where(linkId='census_men').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='census_women').answer.exists(), %resource.repeat(item).where(linkId='census_women').answer.value.first(), 0)), 0)
iif(%resource.repeat(item).where(linkId='tetra_baby_girl').answer.exists(), %resource.repeat(item).where(linkId='tetra_baby_girl').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='tetra_pregnant_women').answer.exists(), %resource.repeat(item).where(linkId='tetra_pregnant_women').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='tetra_baby_boy').answer.exists(), %resource.repeat(item).where(linkId='tetra_baby_boy').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='tetra_baby_boy').answer.exists(), %resource.repeat(item).where(linkId='tetra_baby_boy').answer.value.first(), 0) + iif(%resource.repeat(item).where(linkId='tetra_baby_girl').answer.exists(), %resource.repeat(item).where(linkId='tetra_baby_girl').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='tetra_child').answer.exists(), %resource.repeat(item).where(linkId='tetra_child').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='tetra_pregnant').answer.exists(), %resource.repeat(item).where(linkId='tetra_pregnant').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='tetra_breastfeeding').answer.exists(), %resource.repeat(item).where(linkId='tetra_breastfeeding').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='tetra_absent').answer.exists(), %resource.repeat(item).where(linkId='tetra_absent').answer.value.first(), 0)
iif(%resource.repeat(item).where(linkId='tetra_refusal').answer.exists(), %resource.repeat(item).where(linkId='tetra_refusal').answer.value.first(), 0)
%resource.repeat(item).where(linkId='p_location').answer.value.first() & ' community'
ESPEN MDA demo Form 3 (the treatment tally): village census plus per-drug treated counts by sex and age band with reasons-not-treated. Template-based extraction: one ICRDeliveryUnit community Group for the village, one Group-subject ICRMedicationAdministration per answered drug block (the treatment event — tablets into people are treatment, not a supply transfer), and one ICRAdministrativeCoverage MeasureReport per answered drug block — measure icr-mda-treatment-coverage, stratified by sex, age-band, and disposition, the same cube as example-mda-treatment-tally (espen-forms, remapped espen-remap).
Select the Health facility / Sub district
Enter the ID of village / location / site
Boys from 6 months to less than 7 years treated
Girls from 6 months to less than 7 years treated