Page tree
Skip to end of metadata
Go to start of metadata

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:

GroupsParticipants
group16
group118
group15
group15
group1<null>
group245
group276
group2104
group216

group2

3
group35
group317
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.

GroupsParticipants_SUM
group134
group2244
group3<error>

Additional Information

How to Replicate the SUMIF Function in Datameer


  • No labels