Return rates on the weekly report are always rounded down

Bug huntEasyPython · PostgresDatabase15 min

OPS-902: Return rates on the weekly sheet are too low

Reported by: Mireille Cole (Operations, Birdsong Outdoor) · Priority: Low · Component: Weekly reports

Symptom

Every Monday I compare the return rate column of the weekly report with my own spreadsheet. The report is always a bit lower: Trail Boots shows 42 and my sheet says 42.9; Headlamp shows 33 against my 33.3. The counts of lines sold and returned match my sheet exactly, only the percentage differs (my calculation is in the attached file).

Steps to reproduce

Run the return rate report on the sample data and compare the percentage column with returned lines divided by sold lines.

Expected

The percentage of sold lines that were returned, rounded to one decimal: Trail Boots 42.9, Rain Shell 12.5, Wool Socks 0.0, Day Pack 100.0, Headlamp 33.3.

Actual

Trail Boots 42, Rain Shell 12, Wool Socks 0, Day Pack 100, Headlamp 33.

How it works

1Fix the problemin a real codebase.
2Use your ownAI, or none.
3Submit, then answera few short questions.
4Get your gradeand feedback.

Guides that use this problem

All guides

SQL Debugging Interview Questions (With a Real Database)Skill guide

More on SQL practice

View all

Weekly agent workload shows inflated comments and minutesThe workload report multiplies comments and minutes and shows 3 rows for 4 agents.Bug huntMedium Support page for failed payments takes secondsA support lookup on a busy payments table is slow; the fix must not block writes.Bug huntMedium Merge duplicate customer accounts without losing anythingMerge duplicate customers into the oldest account, keep orders, points and addresses.Bug huntMedium