Trace the total to the records
Silent video.

[0–6]
Start with the measure • Quality depends on the reporting use. • Sum order amounts • Fixed snapshot + period • Check order IDs • Illustrative SAR amounts · not revenue
The measure is the sum of hypothetical order amounts in SAR, not recognised revenue. The route fixes a source snapshot and period, then checks order IDs before calculating.

[6–12]
Inspect the join • Order amounts can repeat at shipment grain. • 4 source orders • 7 left-join rows • O-1 · 100 • O-2 · 100 • O-3 · 250 • O-4 · 500 • SAR 950 → naive SAR 1,550
Four source orders stay visible: O-1 100, O-2 100, O-3 250 and O-4 500 SAR. Copies fan into seven left-joined rows in multiplicities 2, 1, 3 and 1. No source amount changes. O-4 is retained once without a matching shipment because this example confirms the shipment source is complete and O-4 has none. The original sum is SAR 950; summing repeated joined amounts naively gives SAR 1550. These are hypothetical order amounts, not revenue or client results.

[12–18]
Use the record key • Equal amounts do not make two orders duplicates. • O-1 • O-2 • 100 SAR • Equal amounts, different order IDs • 100 + 100 = 200 SAR
Two different order identifiers, O-1 and O-2, remain separate above equal SAR 100 amounts. The two amounts contribute SAR 200 together; matching amounts are not a duplicate-record key.

[18–24]
Show missing states honestly • Unavailable is not zero. • Zero • Unknown • Not applicable • Unavailable • Failed source import → Unavailable • Four distinct states
Four reviewed symbols name zero, unknown, not applicable and unavailable. A failed source import connects to unavailable. It does not turn into zero or any of the other two states.

[24–30]
Retain and rerun evidence • Record the definition, period, role and owner. • Correction to verify • Rerun source checks • Rerun model checks • Definition · period · role · owner • Check another permitted role • Keep evidence · result pending
A correction branches into source and model checks, with definition, period, role and owner recorded. Another permitted role is checked as well. Evidence must be retained and rerun after changes; no successful acceptance result is claimed.