Valid CSV, Wrong Total: The Housing Data Aggregation Trap

A housing table can have valid numbers, unique row keys and correct regional subtotals, yet still produce a national total that is almost twice as large as it should be. The problem is the level of ag