---
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."
tags: ["ANYOF ", "Remove Dimensions", "functions ", "Pigment Boards", "Pigment Blocks", "formula syntax", "Modeling and Formulas"]
updated: 2025-05-30T09:38:43Z
published: 2025-08-22T10:57:28Z
canonical: "kb.pigment.com/anyof-function"
---

> ## 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)