+ Start a Discussion
Mohammad ShahnawazMohammad Shahnawaz 

We have a picklist field of various occupation on a child object. Picklist values are: Driver Mason Carpenter Tailor Student I am trying to get a total of driver count on Parent object and also a total of driver count on child object. Please help.

ShirishaShirisha (Salesforce Developers) 
Hi Shahnawaz,


You can query the records which has picklist value as Driver as below.
Select count() from Object where Occupation='Driver';
which returns the count of records which has Driver value.

Please mark it as best answer if it helps you to fix the issue.

Shirisha Pathuri

Daniel Anthony 5Daniel Anthony 5
This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information...Kammerjäger München
Daniel Anthony 5Daniel Anthony 5
Thank you very much for this useful article. I like it. ko cuce (https://www.kocuce.com.tr)