Skip to main content Stream TDX Bengaluru on Salesforce+. Start learning the critical skills you need to build and deploy trusted autonomous agents with Agentforce. Register for free.
Topics#FormulasPregunta de Synthia Beauvais (Inactive)
Synthia Beauvais (Inactive) (Veritiv) preguntó en #Formulas
13 jul 2016, 4:05 p.m.

Custom Formula Field - Data Quality Scores

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

Custom Formula Field - Data Quality Scores

MAX SCORE: 5

MIN SCORE: 0

Thanks in advance! 

 
3 respuestas
  1. Rajan Patel (Micron)
    13 jul 2016, 8:54 p.m.
    Try something like this.

    ((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 

    ) 

    * (20))

    + 

    (IF( ISBLANK( MailingStreet ), 0, 1) * (3.333))+ 

    (IF( ISBLANK( MailingCity ), 0, 1)* (3.333)) + 

    (IF( ISBLANK( MailingState ), 0, 1)*(5))+ 

    (IF( ISBLANK( MailingCountry ), 0, 1)*(5))+ 

    (IF( ISBLANK( MailingPostalCode ), 0, 1)*(3.333)) +

    (IF( ISBLANK(FirstName ) ,0,1) *(10))+ 

    (IF( ISBLANK( LastName ) , 0, 1) *(25))+ 

    (IF( ISBLANK( Email ) , 0, 1) *(25))

    )/20
Cargando
Escribir una respuesta...
0/9000