---
schema_version: "1"
id: 7a376aafd500bc103851f6f1dc192068afb1e709262da00ba25e932d90a42969
title: SUM
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/aggregate-func/sum.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/sum.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: df5a723ec8a4ae14df86e45579d1b251b8a51c6bec27d397b0eb2deb637d129b
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `SUM`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Computes the sum of all input values.

## Syntax

```sql
sum(<expression>)
```

## Arguments

### Required

- `<expression>`: An expression of any numerical type.

## Returns

- `bigint` for integer-type arguments.
- `NUMERIC(38,s)` for `NUMERIC(p,s)` arguments.

Returns NULL if no rows are selected.

## Considerations

- NULL values are ignored in the calculation.
- Returns NULL when applied to an empty set.
- Use `COALESCE` to substitute zero for NULL if necessary.

## Examples

### Calculate Sum

Get the total revenue.

```sql
SELECT sum(amount) AS total_revenue
FROM sales;
```

### Sum by Group

Calculate totals per group.

```sql
SELECT category, sum(quantity) AS total_quantity
FROM orders
GROUP BY category;
```

### Handle Empty Results

Use COALESCE to return zero for empty sets.

```sql
SELECT coalesce(sum(amount), 0) AS total
FROM orders
WHERE order_date > '2024-12-31';
```

## Related Documentation

- [AVG](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/avg.md)
- [COUNT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/count.md)
- [Aggregate Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/aggregate.md)