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.

Excel equivalent

Back to Top

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]

Back to Top

Similar functions