sum() (aggregation function)

Calculates the sum of Expr across the group.

Note

This function is used in conjunction with the summarize operator.

Syntax

sum (Expr)

Name	Type	Required	Description
Expr string	✓	Expression used for aggregation calculation.

Returns the sum value of Expr across the group.

This example returns the total number of deaths by state.

StormEvents 
| summarize EventCount=count(), TotalDeathCases = sum(DeathsDirect) by State 
| sort by TotalDeathCases

Results

The results table shown includes only the first 10 rows.