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

Additional information

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.

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