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)
booleanBlockcan be of any Dimension(s). The data type should be ‘Boolean’.
Returns
Type | Output Structure (Dimensions) |
|---|---|
Metric | No Dimensions, just |
Examples
Case | Results | Return Type |
|---|---|---|
| A Metric with no Dimension and a result of | Metric |
Excel equivalent
Not applicable.