### Browse by categories

- All
- Collaboration
- Configuration & Data Management
- CPQ and Billing
- Customer Service & Support
- Desktop Integration
- Einstein Analytics
- Email Marketing
- Journey Management
- Mobile
- Mobile Messaging
- Packaging, Uploading & Installing Apps
- Reports & Dashboards
- Sales & Marketing
- Security
- Social Marketing
- Trailhead Challenges
- Additional Products

# How to count 3 picklist values(each is a set of numbers which are actually % values) and the 4th field is a formula which is a %?

((VALUE(TEXT(picklist1_Percentage__c)))+

(VALUE(TEXT(picklist2_Percentage__c))) +

(VALUE(TEXT(picklist3_Percentage__c))) +

xxx_formula__c *100 )/100

The return type for the above is percentage. The formula works fine if the field values of all 3 picklist fields are entered. If any one picklist field is empty, then the calculation doesn't work. I am unable to use NOT(ISBLANK) for picklists as it throws an error. How can the sum of all the above fields can be done even if one o the fields is empty?

Eldon KuzhyelilHey,

Can you try with the following formula,

Regards

## All Answers

Yasser NabanguiHello,

Maybe you can use a "0" value as default value. So you will have "0" instead of BLANK value.

Eldon KuzhyelilHey,

Can you try with the following formula,

Regards

N S@Eldon Kuzhyelil

Thank you. That worked :)