function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Count the number of Activities not being related to an account or opportunity

I need to improve the quality of our data.  A lot of our reps are creating and completing activities without relating it to the proper record.  Is there an easy way to calculate a formula that divides the number of those describes activities with the total count.


Number of Unrelated Activities marked as closed/Total number of Completed.



Steve :-/Steve :-/
You can probably hack-up the Data Quality Analysis Dashboards available on the Appexchange to do this.

Hi Heese,


If you are trying to improve data quality, why not set up validation rules so an Account or Opportunity must be selected before saving the Activity?


Good Luck,