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
| Argument | Data type | Description |
| Source | Boolean | The line item to search for any values that match criteria in the Mapping argument. |
| Mapping | List | The line item to use as search criteria. To provide multiple mappings, repeat this argument and separate each with a comma. |
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
Examples
Example 1: Strategic account regional overviews
Example 2: Inventory exception alerting
Example 3: Transactional travel approval auditing
Example 4: Multi-dimensional marketing saturation matrix
