---
title: "Use the ANYOF Function to Remove Dimensions from Boolean Blocks"
slug: "anyof-function"
description: "Learn to use Pigment's ANYOF function to remove Dimensions and verify if at least one Boolean cell is TRUE in a Block."
updated: 2025-05-30T09:38:43Z
published: 2025-08-22T10:57:28Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ANYOF function

## Description

The ANYOF function removes all Dimensions from the Boolean Blocks added in the argument. It returns `True` if at least one cell in the Block is `True`.

It does not require the source Metric Block and the target Metric to have the same Dimensions in order to work correctly as it results in a Metric with no Dimensions.

## Syntax

`ANYOF(booleanBlock)`

- `booleanBlock` can be of any Dimension(s). The data type should be ‘Boolean’.

## Returns

| Type | Output Structure (Dimensions) |
| --- | --- |
| Metric | No Dimensions, just `True` if the Boolean Block contains at least one true value. |

## Examples

| **Case** | **Results** | **Return Type** |
| --- | --- | --- |
| `ANYOF('Active Employees')` where `Active Employees` is a Metric with a Dimension `Employees` containing at least one active employee | A Metric with no Dimension and a result of `True` | Metric |

## Excel equivalent

Not applicable.

## See also:

[**By modifier**](/v1/docs/by-modifier)

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style><style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>
