Skip to main content
Topics#Data ManagementDomanda di Lindsay Davies
Lindsay Davies ha fatto una domanda in #Data Management
16 giu 2016, 11:45

Formula is not calculating consistent results

I am trying to calculate a score based on the number of fields where the picklis value equals 'No'.  I am uaing the formula below and sometimes it calculates perfectly but other times it produces the wrong result.  Can anyone tell me where I am going wrong?

 

IF(CONTAINS(RecordType.Name,"Closed"),

 

IF(ISPICKVAL(Name_Address_And_Contact_Details__c,"No"),1,0)+

 

IF(ISPICKVAL(Is_This_a_Complaint__c,"No"),1,0)+

 

IF(ISPICKVAL(Complainant_Type__c,"No"),1,0)+

 

IF(ISPICKVAL(Complaint_About_Whom__c,"No"),1,0)+

 

IF(ISPICKVAL(Summary_Of_Complaint__c,"No"),1,0)+

 

IF(ISPICKVAL(Product_Type__c,"No"),1,0)+

 

IF(ISPICKVAL(Is_It_Claims_Related__c,"No"),1,0)+

 

IF(ISPICKVAL(Receipt_Date__c,"No"),1,0)+

 

IF(ISPICKVAL(Complaint_Issue__c,"No"),1,0)+

 

IF(ISPICKVAL(Resolved_To_Customer_Satisfaction__c,"No"),1,0)+

 

IF(ISPICKVAL(Decision__c,"No"),1,0)+

 

IF(ISPICKVAL(Decision_Summary__c,"No"),1,0)+

 

IF(ISPICKVAL(Cost__c,"No"),1,0)+

 

IF(ISPICKVAL(Root_Cause_Where__c,"No"),1,0)+

 

IF(ISPICKVAL(Root_Cause_Why__c,"No"),1,0),0)
7 risposte
  1. Lindsay Davies (Allianz Insurance plc)
    16 giu 2016, 12:48
    Thanks All.  Support have come back to me now and it seems the formula result is actually not on the page layout.  The one on the page layout is being update by a workflow rule (I didn't build this :)  they are going to look into it for me so i'll leave it with them. Thanks for you help though

     

     
Scrivi una risposta...
0/9000