I need to create a report that shows the total number of accounts in our system, and will allow me to calculate out of the total number of accounts, how many have activities (considering these accounts "worked").
I've tried a few different ways, but the problem is, activities are duplicating accounts when I run the report, so the "percentage of accounts worked" is off.
I need to be able to use this report to put a guage component on a dashboard, simliar to this:
10 个回答
For the Custom Summary Formula at the bottom of the Report I used this Formula
