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.
Question
Showing accurate percentage in column totals
+7
+17- Nintex Employee
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.