The idea in practice

Replacing a missing value with zero can distort an average, a total or a ranking. Keep missingness visible and decide what to do with it based on the question rather than a convenient default.

Try the distinction on a real task

This is an illustrative request, not a customer result or a promise that every connected service supports every step.

Keep missing revenue values separate from genuine zeros and explain the effect on the total.

How to apply it

  • Identify missing states
  • Choose an explicit treatment
  • Review its effect

What to check

Check how many records were excluded or changed.

A mistake to avoid

Do not silently clean away the uncertainty that the decision needs to see.

Using Bris for this work

Analytical work starts with a question and a defined dataset. Bris can help organize sources, examine figures and prepare a reviewable output. Check the units, date window, missing values and formulas before using the result to make a decision.