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:
| Group | User | Login |
|---|---|---|
| 1 | adam | true |
| 1 | bob | true |
| 2 | chris | true |
| 2 | dave | false |
| 2 | eric | false |
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.
| GroupBy | Group_And returns |
|---|---|
| 1 | true |
| 2 | false |