+ 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

SteveMo__cSteveMo__c
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