Prompt·Data integrity and analytics·D01
Missing vs zero vs stale
Finds where 'we don't know' turns into 0 and then into a wrong total.
Prompt
Identify where the application confuses missing, zero, unavailable, estimated, stale, and not applicable. Trace the consequences through storage, calculations, and presentation.
- What it returns
- Each field with how each absence state is stored, how calculations treat it, and how it displays.
- Skip it when
- Data with no optional values.
- Changes
- Changes nothing
- Sessions
- Look first, then fix in a new session
- Tools
- Repository and read-only database access.
- Also called
- Missing versus zero versus stale
Related prompts
- Fallbacks that look like real dataPromptFinds screens that show a confident zero or an empty list when the real answer is 'we could not load this'.
- Where did this number come from?PromptChecks that every number on screen can be traced back to a source document.
- Rounding and unit mix-upsPromptFinds money and percentage values that change scale or lose precision along the way.
More in Data integrity and analytics.