Aggregation function that can be used with Boolean line item on source and result. A list of Boolean items is analyzed. The result is true when the Boolean value for all list items is true.
Syntax
x[ALL:y]
where:
- x: Boolean-formatted source line item
- y: list-formatted source line item that uses a list matched to a result dimension
Format
| Input Format | Output Format |
|---|---|
|
x: Boolean y: List item |
Boolean |
Arguments
The function uses the following arguments:
- x: Boolean: Expression that equates to a Boolean result
- y: List item: list-formatted source line item
Constraints
The function has the following constraints:
- The function requires two parameters.
- Result line item must be Boolean-formatted.
- The result or target line item must have a dimension applied to it that matches the list used to format the y parameter source line item.
Excel equivalent
Example
A Pay Details source module shows staff locations and bonus awards. The module has a list dimension on rows for employee. Two source line items are on columns: Location is list-formatted on the Organization list and Bonus is Boolean-formatted. In Birmingham and Munich all employees have been awarded a bonus:
A results module has Organization as a dimension on Columns. We can then use ALL in a Boolean-formatted result line item to show where it is true that all employees at a location have been awarded a bonus:
Pay Details.Bonus[ALL:Pay Details.Location]
In this second example, a Pay Details source module shows staff locations and car allowances. The module has a list dimension on rows for Employees. Two source line items are on columns: Location is list-formatted on the Organization list and Car Allowance? is Boolean-formatted. In Paris and Berlin all employees have a car allowance:
A results module has Organization as a dimension on Columns. We can then use ALL in a Boolean-formatted result line item to show where it is true that all employees at a location have a car allowance:
Pay Details.Car Allowance[ALL:Pay Details.Location]
