GROUPOR
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:
group | user | login |
---|---|---|
1 | adam | true |
1 | bob | true |
2 | chris | true |
2 | dave | false |
2 | eric | false |
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.
GroupBy | Group_Or |
---|---|
1 | true |
2 | true |