GROUPSUM

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:

First create a group using GROUPBY(#RawData!Groups)

Then use the GROUPSUM(#RawData!Participants). The result is the sum of the values of the column in relation to the GROUPBY() column.

Additional Information

Replicate the SUMIF Function 

The SUMIF function can be accomplished by combining the two separate functions GROUPSUM and IF.

Example

Given the following data:

first create groups that contain the values you want to sum. This example excludes values less than 2 from the total sum.

GROUPSUM( IF( (#Data!Value >= 2); #Data!Value; 0) )

The result of this formula executes the GROUPSUM function with the specified conditional statement. Both the groups had a value that was 1. This value was changed to 0 as specified in the IF statement. The new sum of the groups in this example are displayed in the Total_Value1 column.