Aggregation function that can be used with Boolean line item on source and result. A list of Boolean items is analyzed. The result is true when the Boolean value for any list item is true.
- x: Boolean-formatted source line item
- y: list-formatted source line item that uses a list matched to a result dimension
|Input Format||Output Format|
y: List item
The function uses the following arguments:
- x: Boolean: Expression that equates to a Boolean result
- y: List item: list-formatted source line item
Use ANY with the Users list
You can reference the Users list with the ANY function. However, you cannot reference specific users within the Users list as this is production data, which can change and make your formula invalid.
The function has the following constraints:
- The function requires two parameters.
- Result line item must be Boolean-formatted.
- The result or target line item must have a dimension applied to it that matches the list used to format the y parameter source line item.
A Pay Details source module shows staff locations and bonus awards. The module has an Employee list dimensioned on Rows. Two source line items are on Columns: Location is list-formatted on the Organization list and Bonus is Boolean-formatted. In Birmingham, Munich, and Los Angeles at least one employee has been awarded a bonus:
The Any Employee Roles Locations results module has Organization as a dimension on Columns. We can then use ANY in a Boolean-formatted result line item to show where it is true that any employee at a location has been awarded a bonus:
Pay Details.Bonus[ANY:Pay Details.Location]
In this second example, a Pay Details source module shows staff Location and Car Allowance. The module uses the Employees list a dimension on Rows. Two source line items are on columns: Location is list-formatted on the Organization list and Car Allowance? is Boolean-formatted. In London, Paris, and Berlin at least one employee has a car allowance:
The Any Employee Car Locations results module has Organization as a dimension on Columns. We can then use ANY in a Boolean-formatted result line item to show where it is true that at least one employee at a location has a car allowance:
Pay Details.Car Allowance[ANY:Pay Details.Location]