# Showing accurate percentage in column totals

I understand what is going on here, so this might be more of an idea than a problem.

I have a table with opportunity products showing win percentage. ($ Awarded/ $ Bid) If I try to use column totals to show the win percentage as a whole, the numbers are misleading. Using Sum, it adds up the values so you can end up with over 100%. Using average, it averages the percentages displayed in the table rather than calculating a true average based on the underlying data.

I have a table with opportunity products showing win percentage. ($ Awarded/ $ Bid) If I try to use column totals to show the win percentage as a whole, the numbers are misleading. Using Sum, it adds up the values so you can end up with over 100%. Using average, it averages the percentages displayed in the table rather than calculating a true average based on the underlying data.

1

#### Categories

- 4.9K Questions
- 914 Ideas
- Discussion Categories
- 96 General
- 7 Community Feedback
- 3 Community Info

## Comments