You need to sign in to do that
Don't have an account?
Jack A 2
How to count if a particular field has some value?
I want to count how many Contact has value under description field using for loop. Similarly if Contact object has custom field then how to count those field which has some value
SELECT COUNT() Amo__c FROM Contact WHERE Description != null
The above query is not working
SELECT COUNT() Amo__c FROM Contact WHERE Description != null
The above query is not working
If you want to count number of contact where description is not null then you can do it like this or else you can do it with one more way
Please let me know if you need more guidance on this.
Thanks,
Keyur Modi
All Answers
Perhaps you can create a formulae field on contact of type checkbox, that cn check this description field is null or not for you.
Then use this formulae field in your query.
If you want to count number of contact where description is not null then you can do it like this or else you can do it with one more way
Please let me know if you need more guidance on this.
Thanks,
Keyur Modi