GROUPAND

Syntax

GROUPAND(<Boolean>)

Description

This function checks if all arguments are true for an entire column of Boolean values that has been grouped with the GROUPBY() function.

The function returns true if all arguments are true.

The function returns false if any of the arguments are false. 

This is an aggregate function

Example

Given the following data:

GroupUserLogin
1adamtrue
1bobtrue
2christrue
2davefalse
2ericfalse

First create a group, e.g. GROUPBY(#RawData!group)

GroupBy
1
2

Then use the GROUPAND(#RawData!login), and the results are a Boolean value based on the AND() function of your grouped data.

GroupByGroup_And returns
1true
2false