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
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]