Description | The |
Syntax | SUM( |
Output | numeric |
Variables
number: the numeric field to be summed.
Example
SUM(Value) Over (Partition by Group)
ID | Group | Value | SUM |
1 | A | 10 | 45 |
2 | A | 20 | 45 |
3 | A | 15 | 45 |
4 | B | 30 | 70 |
5 | B | 40 | 70 |
Calculates the total sum of a specified numeric field within a range or partition
Updated over a month ago