Handle missing values honestly

Treat blank, unknown, not applicable, and zero as different meanings instead of one vague problem. You’ll decide how each case should appear in a report so the data does not hide uncertainty or create false totals.