---
schema_version: "1"
id: 88c168a9223a0979837dc189e7f91d2db8ea6d12cb187410a88e016870b6336b
title: Aggregate Functions
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-aggregate-intro.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-intro.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: c07e6081c9e2ebe48d0ec5e380f72350cdfe7ae1acf4e4e2f0b11c4ab035ebc9
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# Aggregate Functions

Aggregate functions perform operations across columns.

CRM Analytics supports the following aggregate functions.

- **[avg()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-avg.md)**


    Takes the average of row values in a given column.

- **[count()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-count.md)**


    Returns the number of rows that match a specified condition in a column.

- **[min()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-min.md)**


    Returns the lowest row value in a numeric column.

- **[max()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-max.md)**


    Returns the highest row value in a numeric column.

- **[sum()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-sum.md)**


    Returns the sum of all rows values in a numeric column.

- **[stddev_pop()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-stddev-pop.md)**


    Returns the population standard deviation of the values in a field. Accepts measure fields as input. This function does not accept expressions.

- **[stddev_samp()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-stddev-samp.md)**


    Returns the standard deviation of values in a field. Accepts measure fields as input. This function does not accept expressions.

- **[var_pop()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-var-pop.md)**


    Returns the population variance of the values in a field. Accepts measure fields as input. This function does not accept expressions.

- **[var_samp()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-var-samp.md)**


    Returns the sample variance of the values in a field. Accepts measure fields as input. This function does not accept expressions.

- **[regr_intercept()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-regr-intercept.md)**


    Returns the y-intercept value of a regression line.

- **[regr_slope()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-regr-slope.md)**


    Returns the slope of a regression line between two numerical fields.

- **[regr_r2()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-regr-r2.md)**


    Returns the R-squared, or goodness-of-fit value for a regression.

- **[percentile_cont](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-pct-cont.md)**


    Calculates a percentile based on a continuous distribution of the column value.

- **[percentile_disc](https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-pct-disc.md)**


    Returns the value corresponding to a given percentile. Accepts measure fields as input.