How can I get scoring on custom object using yes/no picklist fields and getting a percentage

Question

Hello,

I've created a custom object with 10 questions that all have a yes/no choice in the picklist field. Example: If 7 of these questions have 'yes' answers, then the record would score a 70%. How can I create a formula field to calculate this?

The custom fields have names like X1__c and there are only 10, but this is doing my head in.

Thank you!

Christian Martínez Lopez · Accepted Answer

Right! I forgot you used Picklist fields not check fields, change the formula to:

IF(ISPICKVAL(X1__c,"YES"),0.1,0) 
+ 
IF(ISPICKVAL(X2__c,"YES"),0.1,0) 
+ 
IF(ISPICKVAL(X3__c,"YES"),0.1,0)
...

Saludos, CM

Christian Martínez Lopez · Answer

Hello Jessica, you just need to create a new field in your custom object:   Data type: Formula   Formula Return Type: Percent ( 1  decimal place)   Formula:  IF(X1__c=TRUE,0.1,0)  +  IF(X2__c=TRUE,0.1,0)  +  IF(X3__c=TRUE,0.1,0) + .... IF(X10__c=TRUE,0.1,0) The formula would transform each check to 0.1 (or 10%) and uncheck to 0, if all of the 10 questions are check the total will be 1.0 or 100% in your page layout.   Cheers, CM

How can I get scoring on custom object using yes/no picklist fields and getting a percentage

Data Management

相关学习

更多帮助