-
Formula Field in Aggregate Salesforce Query
Can any body suggest me how can i use the formula field in a aggregate soql query because when i am using the field it is throwing error that this field can't be grouped or aggregated
like
select count(id), formula__c from Object__c group by formula__c
-
5 Replies
-
Hello Ajit,
Formula fields are not "groupable" i.e they are not usable in the GROUP BY clause of a SOQL query.
-
Hi Ajit,
Formula Fields cannot be used with the group by clause in SOQL query
You can check whether a field is "groupable" or not using DescribeFieldResult.
Example:
Schema.DescribeFieldResult resultObject= Object__c.formula__c.getDescribe();
if(resultObject.groupable == true){
formula__c is groupable
}else
formula__c is not groupable-
This reply was modified 8 years, 7 months ago by Ravi.
-
This reply was modified 8 years, 7 months ago by
-
Hi Ajit
To Check whether any field is "groupable" or not,Please follow the below procedure
Schema.DescribeFieldResult fieldDescribe = ObjectName.FieldName.getDescribe();
if(fieldDescribe.groupable == true){
Then Our Field is Groupable
}
Thanks
-
Formula fields are not "groupable" - that is, they are not usable in the GROUP BY clause of a SOQL query. There is limitation like Formula fields can't use in the group by Clause.
-
Hi
Formula fields are not groupable they are not usable in the GROUP BY clause of a SOQL query.
Log In to reply.
Popular Salesforce Blogs
The Ultimate Guide to Choosing the Right Salesforce Development Company
Are you looking to implement Salesforce for your business but unsure how to customize it to fit your needs? Or perhaps you have already implemented…
Decoding Salesforce Summer 16 Release Notes
It has been 2 months since the latest major salesforce release, the spring 2016 edition. The new release again aimed at bridging the gaps left…
Work smarter with Salesforce Workbench
Salesforce Workbench is one of most essential tools packed with abundant features that come as a blessing for the admins and developers! It allows you…