Support for Field Types in Aggregate Functions

Aggregate functions provide a powerful means to analyze your records, but they are not relevant for all field types. For example, using an aggregate function on a base64 field type would not return meaningful data, so base64 fields do not support any of the aggregate functions. The following table lists support by the aggregate functions for the primitive data types.

Data Type	`AVG()`	`COUNT()`	`COUNT_DISTINCT()`	`MIN()`	`MAX()`	`SUM()`
base64	No	No	No	No	No	No
boolean	No	No	No	No	No	No
byte	No	No	No	No	No	No
date	No	Yes	Yes	Yes	Yes	No
dateTime	No	Yes	Yes	Yes	Yes	No
double	Yes	Yes	Yes	Yes	Yes	Yes
int	Yes	Yes	Yes	Yes	Yes	Yes
string	No	Yes	Yes	Yes	Yes	No
time	No	No	No	No	No	No

In addition to the primitive data types, the API uses an extended set of field types for object fields. The following table lists support by the aggregate functions for these field types.

Data Type	`AVG()`	`COUNT()`	`COUNT_DISTINCT()`	`MIN()`	`MAX()`	`SUM()`
anyType	No	No	No	No	No	No
calculated	Depends on data type^*	Depends on data type^*	Depends on data type^*	Depends on data type^*	Depends on data type^*	Depends on data type^*
combobox	No	Yes	Yes	Yes	Yes	No
currency	Yes	Yes	Yes	Yes	Yes	Yes
DataCategoryGroupReference	No	Yes	Yes	Yes	Yes	No
email	No	Yes	Yes	Yes	Yes	No
encryptedstring	No	No	No	No	No	No
ID	No	Yes	Yes	Yes	Yes	No
masterrecord	No	Yes	Yes	Yes	Yes	No
multipicklist	No	No	No	No	No	No
percent	Yes	Yes	Yes	Yes	Yes	Yes
phone	No	Yes	Yes	Yes	Yes	No
picklist	No	Yes	Yes	Yes	Yes	No
reference	No	Yes	Yes	Yes	Yes	No
textarea	No	Yes	Yes	Yes	Yes	No
url	No	Yes	Yes	Yes	Yes	No

^* Calculated fields are custom fields defined by a formula, which is an algorithm that derives its value from other fields, expressions, or values. Therefore, support for aggregate functions depends on the type of the calculated field.

Tip

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.