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

Syntax

GROUPAND(<Boolean>)

Description

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

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

The function returns false if all 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 using GROUPBY(#RawData!group)

GroupBy
1
2

Then use the GROUPOR(#RawData!login), and the results is a Boolean value based on the OR() function of your grouped data.

GroupByGroup_Or
1true
2true
  • No labels