-
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, 12 months ago by Ravi.
-
This reply was modified 8 years, 12 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
How to Automate Sewing Machine Inventory Management with Salesforce
Keeping track of stock is crucial in the ever-changing sewing machine repair and retail market. Salesforce's potential for automation means it might help firms save…
3 Ways Salesforce Data Cloud is Transforming Healthcare
Healthcare is a constantly shifting industry and data can aid in making informed decisions that improve patient care. Despite this, the vast amounts of data…
Engaging User Communities with Salesforce Experience Cloud
For years, Salesforce customers have leveraged communities to deliver Salesforce-powered interactions to their users. However, these communities were limited to singular portals and websites. In…
