UAT-017: Region totals wrong
Hi, testing the Q1 dashboard: West shows $60,740 but my Excel says $64,461. Central is the other way round. Europe matches. Total matches. Logged as a defect, severity high. Screenshot and my Excel attached.
UATUAT-017Drill
"The Region total doesn't match Excel"
Nina's UAT finding says the report's region totals don't match her Excel. Reproduce it, explain it and decide: defect or requirement mismatch?
Labels: uatregionsexcel-mismatch
Why the business cares UAT is where the business decides whether to trust a report. Calling a definition difference a "bug" (or a real bug "by design") loses that trust for months.
Brief
What you are expected to do
- Reproduce both numbers from the data.
- Explain the difference in one sentence.
- Decide: defect, requirement mismatch, or test error, and record the UAT outcome.
- Propose what the report should do so testers don't trip over it again.
Deliverables
- UAT log entry: test case, expected, actual, evidence, status, owner, notes
- Reply to Nina
Evidence
- nina_excel_region_totals.csv
- report_region_totals.csv
- Sales terminology (team wiki)
- orders.csv
- customers.csv