Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

I'm trying to use an aggregate query, but one of the fields I want to group by is not groupable (saw it in the soql error and then verified groupable=false in the metadata).

It's just a number field that holds an integer (number 2,0 in salesforce field spec-speak).

Is there a trick to make it groupable? Any way around this problem? I don't want to write hundreds of lines of code just to average a list by this field.

share|improve this question
    
Can you provide more specific detail about the configuration of the custom field which you are trying to group by? Support for Field Types in Aggregate Functions –  Mark Pond Dec 31 '12 at 20:28
add comment

2 Answers

up vote 2 down vote accepted

I'm not 100% sure what makes it "groupable". The Considerations When Using GROUP BY does mention it:

Some object fields have a field type that does not support grouping. You can't include fields with these field types in a GROUP BY clause. The Field object associated with DescribeSObjectResult has a groupable field that defines whether you can include the field in a GROUP BY clause.

Although not exactly elegant, you could try to copy the not groupable field to a groubable field via a workflow rule and then group by that one instead.

share|improve this answer
    
Did the extra field copy with a workflow. Salesforce seems arbitrary sometimes. –  Shane McLaughlin Jan 1 '13 at 19:41
add comment

It appears that 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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.