Here's the dashboard widget, where the total is the sum of each conversion % above it.
However, on the underlying report the total properly displays as the formula dictates (in this case, the 187/1289 = 14.5%). Here is the underlying report. The CONV % is simply the # Won deals divided by # Meetings Held (this is a 1 or 0 field on the opportunity).
The conversion formula is as follows:
Thank you!
4 réponses
If you tell the Dashboard component to "Total" a column, it does exactly that -- totals. Which, in the case of Percents is never a good idea (since the sum of a set of percents is not the same as the percent of the difference between 2 other totals). There's no other option on the dashboard component configuration.
