Showing accurate percentage in column totals

  • 1
  • Problem
  • Updated 2 years ago
  • Not a Problem
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.
Photo of Jared Jones

Jared Jones

  • 2,214 Points 2k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Yup.  I'm not sure we'd ever be able to know that the table was built on aggregations from underlying data.  You may have to create a separate aggregate model that does the average calculation on all the individual records - but doesn't break things out like you ahve on the table...  Then show that "total average" value somewhere else on the page.