The ANY aggregation function returns a TRUE result for any value that matches specific Boolean criteria in a source module.

For example, you can use the ANY aggregation function to identify any employees in an organization with a car allowance.

Source[ANY: Mapping, ANY: Mapping 2, etc.]

Arguments

Argument Data type Description
Source Boolean The line item to search for any values that match criteria in theMappingargument.
Mapping List

The line item to use as search criteria.

If you want to provide multiple criteria, you can repeat this argument.

The ANY aggregation function returns a Boolean result.

Constraints

  • The list that is used to format the mapping line item in the source module must be a dimension of the target line item that uses the ANY aggregation function.
  • The dimensions of the mapping line item must also appear in the source line item.
  • You can reference theUserslist with the ANY function. However, you cannot reference specific users in theUserslist as this isproduction data, which can change and make your formula invalid.

Excel equivalent function

OR

ALL

Examples

In this example, theSalary Detailsmodule has line items on columns, and theEmployeeslist on rows. The module shows employee car allowances and city locations.

TheCar Allowanceline item has a Boolean data type. TheCityline item has a list data type, and is formatted on theCitylist.


 Car Allowance City
Employee A London
Employee B New York
Employee C San Francisco
Employee D
Edinburgh
Employee E
New York
Employee F
London

Below, theAny Employee Car Allowancemodule has theAny location with employee car allowancesline item on rows, and theCitylist on columns. TheAny location with employee car allowancesline item has a Boolean data type.

The formula uses the ANY aggregation function to show any employees with car allowances in different cities.


 London Edinburgh San Francisco New York

Any location with employee car allowances

Salary Details.Car Allowance[ANY: Salary Details.City]

Example with two mappings

Another example uses theSalary Detailsmodule above, but includes an additional部门line item.部门has a list data type, and is formatted on the部门list.


 Car Allowance 部门 City
Employee A Sales London
Employee B
Sales London
Employee C HR San Francisco
Employee D
HR San Francisco
Employee E Marketing New York
Employee F
Finance Edinburgh

Below, theAny Employee Car Allowancemodule has theAny location with employee car allowancesline item on pages, the部门list on rows, and theCitylist on columns. TheAny location with employee car allowancesline item has a Boolean data type.

The formula in the line item uses the ANY aggregation function to show any employees with car allowances in different cities and departments:Salary Details.Car Allowance[ANY: Salary Details.City, ANY: Salary Details.Department].

The formula only returns a TRUE result if any employee in a department or city has a car allowance.


 London Edinburgh San Francisco New York
Sales


HR


Marketing


Finance