1. Calculation functions
  2. All Functions
  3. Aggregation Functions
  4. ANY

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.

Syntax

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

Arguments

ArgumentData typeDescription
SourceBooleanThe line item to search for any values that match criteria in the Mapping argument.
MappingList

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 the Users list with the ANY function. However, you cannot reference specific users in the Users list as this is production data, which can change and make your formula invalid.

Excel equivalent function

OR(opens external page)

Related Anaplan functions

ALL

Examples

In this example, the Salary Details module has line items on columns, and the Employees list on rows. The module shows employee car allowances and city locations.

The Car Allowance line item has a Boolean data type. The City line item has a list data type, and is formatted on the City list. 


Car AllowanceCity
Employee ALondon
Employee BNew York
Employee CSan Francisco
Employee D
Edinburgh
Employee E
New York
Employee F
London

Below, the Any Employee Car Allowance module has the Any location with employee car allowances line item on rows, and the City list on columns. The Any location with employee car allowances line item has a Boolean data type.

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


LondonEdinburghSan FranciscoNew York

Any location with employee car allowances

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


Example with two mappings

Another example uses the Salary Details module above, but includes an additional Department line item. Department has a list data type, and is formatted on the Department list.


Car AllowanceDepartmentCity
Employee ASalesLondon
Employee B
SalesLondon
Employee CHRSan Francisco
Employee D
HRSan Francisco
Employee EMarketingNew York
Employee F
FinanceEdinburgh

Below, the Any Employee Car Allowance module has the Any location with employee car allowances line item on pages, the Department list on rows, and the City list on columns. The Any location with employee car allowances line 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.


LondonEdinburghSan FranciscoNew York
Sales


HR


Marketing


Finance