Showing accurate percentage in column totals

edited November 18, 2016 in Questions
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.

Comments

  • Rob HatchRob Hatch 💎💎💎
    edited September 16, 2016
    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. 
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!