function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Akhil Katkam 5Akhil Katkam 5 

getting error as formula field cannot be grouped in a query cell

Hi Developer  Community , 

i have an apex class where i am querying fields based on the stage name and formula field (month__c) 

here is the code: 
  
[SELECT SUM(Amount) amount, StageName stage ,Month__c month
    FROM Opportunity WHERE StageName NOT IN ('Closed Won') GROUP BY StageName,Month__c];

i am getting an error as :  
[object Object]: ('Closed Won') GROUP BY StageName, Month__c ^ ERROR at Row:1:Column:135 field 'Month__c' can not be grouped in a query call

month__c is a  formula field based on close date , 

can anyone please help me with the solution

Thanks in Advance
Suraj Tripathi 47Suraj Tripathi 47
Hi,

You are getting this because Formula field doesn't support Group By.

-https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_group_by_considerations.htm
-https://trailblazer.salesforce.com/ideaView?id=08730000000HlNtAAK#:~:text=Give%20it%20an%20upvote%20or%20downvote.,-Matthew%20Scholtz&text=Currently%20it%20seems%20that%20formula,clause%20of%20a%20SOQL%20query.


Please mark it as Best Answer if it helps you.

Thanks & Regards
Suraj Tripathi