## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR sumAggregateFunction_start((START)) sumAggregateFunction_start --> sumAggregateFunction_0_0[SUM]:::quoted sumAggregateFunction_0_0 --> sumAggregateFunction_0_1["("]:::quoted sumAggregateFunction_0_1 --> sumAggregateFunction_0_2[DISTINCT]:::quoted sumAggregateFunction_0_2 --> sumAggregateFunction_0_3[<a href="Invantive UniversalSQL/Grammar/Expression" class="internal-link">expression</a>] sumAggregateFunction_0_3 --> sumAggregateFunction_0_4[")"]:::quoted sumAggregateFunction_0_4 --> sumAggregateFunction_end((END)) ``` ## Purpose Group function to sum together individual numerical values. Occurrences of null are considered 0, unless there are only null values. In that case the outcome is null.