• paulravinder
  • NEWBIE
  • 0 Points
  • Member since 2018
  • Salesforce Admin
  • San Diego Workforce Partnership

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
I am trying to create a data quality score on the Contact object for the fields listed in the chart below. I am not quite sure how to calculate the weight. I have started the formula but I am not getting the correct "Actual Value".
 
IF( 
OR( 
ISBLANK(Phone), 
OR( 
CONTAINS(Phone, '000-0000') , 
CONTAINS(Phone, '111-1111') , 
CONTAINS(Phone, '222-2222') , 
CONTAINS(Phone, '333-3333') , 
CONTAINS(Phone, '444-4444') , 
CONTAINS(Phone, '555-5555') , 
CONTAINS(Phone, '666-6666') , 
CONTAINS(Phone, '777-7777') , 
CONTAINS(Phone, '888-8888') , 
CONTAINS(Phone, '123-4567') , 
CONTAINS(Phone, '456-7890')
) 
), 0, 1 
) 

+ 
IF( ISBLANK( MailingStreet ), 0, 1)+ 
IF( ISBLANK( MailingCity ), 0, 1)+ 
IF( ISBLANK( MailingState ), 0, 1)+ 
IF( ISBLANK( MailingCountry ), 0, 1)+ 
IF( ISBLANK( MailingPostalCode ), 0, 1) +
IF( ISBLANK(FirstName ) ,0,1) + 
IF( ISBLANK( LastName ) , 0, 1)+ 
IF( ISBLANK( Email ) , 0, 1)
/9



User-added image

MAX SCORE: 5
MIN SCORE: 0


Thanks in advance!