I have a simple table report per below where the total column sums all the percentages instead of calculating it using total values. How can I fix this?
| Revenue | Target | % Target | |
|---|---|---|---|
| Company A | 500,000 | 1,000,000 | 50.00% |
| Company B | 400,000 | 500,000 | 80.00% |
| Company C | 700,000 | 800,000 | 87.50% |
| Totals | 1,600,000 | 2,300,000 | 217.50% |
A basic table report can’t divide one total by another. It only sums or averages the column, and neither is right.
The fix: Stop trying to get both the breakdown and the correct blended total out of one report, because a single table can’t do it. Use a dashboard instead and show the two numbers separately. If you don’t have a dashboard yet, create one (Reporting > Dashboards), since this approach depends on it.
Recommendation: Splitting it across a dashboard like this is the cleanest way to show the correct 69.57% in basic HubSpot while keeping the per-company detail, and it avoids the misleading 217.5% entirely.
Limitation: The text tile is hardcoded, so it won’t update when your numbers change. You’ll have to edit it by hand, and it can go stale if you forget. Fine for a dashboard that doesn’t change often. For a live figure, you’d need datasets (Operations Hub).
Hope the workaround helps! 
Thank you!
Not a bug. The Totals row just sums each column, so it adds your three row percentages together (50 + 80 + 87.5 = 217.5%) instead of recalculating from the totals. A summed percentage column is never going to give you a meaningful number.
The real overall figure comes from the column totals: 1,600,000 / 2,300,000 = ~69.6%. The standard report builder can’t do that for you, though, because formula fields are row-level only and can’t divide one summed column by another. If you want that 69.6% calculated automatically, you’d need a Dataset (Data Hub Pro/Enterprise) with a summary function. Otherwise just read the Revenue and Target column totals and divide manually.
Note: this reply was drafted with AI assistance and fact-checked by me for accuracy.
Max Buining
HubSpot CRM-specialist
Pipelines · Forecasting · Dashboards
[
LinkedIn →
