Description | The |
Syntax | CUMULATIVE_SUM( |
Output | numeric |
Variables
number: the numeric field to be cumulative summed.
Example
CUM SUM(Value) Over (Partition by Group Order by ID)
ID | Group | Value | CUMULATIVE_SUM |
1 | A | 10 | 10 |
2 | A | 20 | 30 |
3 | A | 15 | 45 |
4 | B | 30 | 30 |
5 | B | 40 | 70 |