Aim/ count how many times the field "first name"is populate on the account object
Aim: count the number of Account records which have the First Name field populated.
Anyone got any ideas how I can do this ?
Looking forward to your response
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
Use the count(fieldname) SOQL function to count records for which the field is not null:
select count(firstname) from Account
This also lets you filter further. For example, if you only want to count how many Calfornia accounts have firstname populated:
select count(firstname) from Account where BillingState = 'California'