1. Calculation functions
2. All Functions
3. Aggregation Functions
4. x[ANY:y]

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.

## Syntax

`x[ANY:y]`

where:

• x: Boolean-formatted source line item
• y: list-formatted source line item that uses a list matched to a result dimension

## Format

Input Format Output Format

x: Boolean

y: List item

Boolean

## Arguments

The function uses the following arguments:

• x: Boolean: Expression that equates to a Boolean result
• y: List item: list-formatted source line item

## Constraints

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.

## Example

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

Here the Summary method selected for the Boolean-formatted result line item is Any. The result for UK, Germany, and USA is therefore TRUE, and for France the result is FALSE.

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