Report Definition: Stockout % by Vaccine

Definition

The calculation represents the number of health centers that are stocked out of at least one vaccine divided by the total number of health centers reporting.

Numerator: Health Centers Stocked-Out of at Least One Vaccine

Denominator: Health Centers Reporting

Tableau Calculation

sum(if
(
(visited=1)
and
(
(([epi_inventory_penta10_existing] = 0) and ([epi_inventory_penta1_existing] = 0))
or ([epi_inventory_pcv10_existing] = 0)
or ([epi_inventory_measles_existing] = 0)
or ([epi_inventory_bcg_existing] = 0)
or (([epi_inventory_polio20_existing] = 0) and ([epi_inventory_polio10_existing] = 0))
or ([epi_inventory_tetanus_existing] = 0)
)
) then 1 else 0 end)

Comments: Tableau does not allow a summation of a summation, so it isn't possible to streamline this calculation with intermediate variables. The logic for testing whether there is a stock-out is included in 'Stockouts - <vaccine name>' calculations as well as in the 'Stockouts - Vaccine' calculation.