Syntax
GROUPSUM(<number>)
Description
Adds its arguments.
Empty or <null> records of a group aren't calculated into GROUPSUM().
Calculating a column with a (or multiple) <error> records always returns an error for its group.
This is an aggregate function.
Example
Given the following data:
| Groups | Participants |
|---|---|
| group1 | 6 |
| group1 | 18 |
| group1 | 5 |
| group1 | 5 |
| group1 | <null> |
| group2 | 45 |
| group2 | 76 |
| group2 | 104 |
| group2 | 16 |
group2 | 3 |
| group3 | 5 |
| group3 | 17 |
| group3 | <error> |
First create a group using GROUPBY(#RawData!Groups)
| Groups |
|---|
| group1 |
| group2 |
| group3 |
Then use the GROUPSUM(#RawData!Participants). The result is the sum of the values of the column in relation to the GROUPBY() column.
| Groups | Participants_SUM |
|---|---|
| group1 | 34 |
| group2 | 244 |
| group3 | <error> |
Additional Information
How to Replicate the SUMIF Function in Datameer