Ask the assistant to break hours down by project, person or day and it returns a row per group. That was capped at 100, which an ordinary agency passes without trying — one report came back "truncated at 100 of 105 rows".
Two things were wrong with what happened next.
The cap was too low. It is now 500. A hundred-odd clients or projects is normal, and a limit reached by asking an everyday question is a limit in the wrong place.
The totals were only partly protected. Total hours were always summed across every group, capped or not. Billable hours, revenue and cost were not — so when the cap bit, the assistant had nothing to quote but the rows in front of it, and said so: "the grand total is based on the 100 returned." It was being honest about a number it had not been given.
Every total now spans everything that matched. When a result is still capped the assistant says so, and shows the largest groups rather than the first alphabetically — but the total beside them is the real one.
The same fix, everywhere else it was needed
Expenses, submitted timesheets and estimates were capped the same way and had no totals at all.
- Expenses and estimates now report a total per currency. Deliberately not one number: both carry their own currency, and adding dollars to euros produces a figure that looks like an answer and is not one.
- Timesheets awaiting approval now report total hours, total entries and how many people are waiting — which is what the question usually is.