You need to sign in to do that
Don't have an account?
Error In Group by query.
Hi All,
Can you help me to solve this error .
THIS IS QUERY :
select Project__c, count(Id),Project__r.Billable_Hours__c, Project__r.Non_Billable_Hours__c,Project__r.Estimated_Hours__c from Case GROUP BY Project__c,Project__r.Billable_Hours__c, Project__r.Non_Billable_Hours__c,Project__r.Estimated_Hours__c
Error Occured In This Query is :
MALFORMED_QUERY:
from Case GROUP BY Project__c,Project__r.Billable_Hours__c, Project__r.Non_Billable_Hours__c
^
ERROR at Row:1:Column:154
field 'Billable_Hours__c' can not be grouped in a query call.
Thank you in advanced :)
You can not group by custom number fields and not the ability to group by formulas is a request on the ideaexchange so you will need to create a workflow rule that copies the number to a text field.
Note that most standard number fields cannot be grouped by as well but a few like account.numberofemployees can be.
Thanks
All Answers
You can not group by custom number fields and not the ability to group by formulas is a request on the ideaexchange so you will need to create a workflow rule that copies the number to a text field.
Note that most standard number fields cannot be grouped by as well but a few like account.numberofemployees can be.
Thanks
Thank you !