Skip to main content

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.

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. 


Reply