function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
HeeseHeese 

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.

 

Thanks

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

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,

Eric