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
Additional information
Use ALL with the Users list
You can reference the Users list with the ALL function. However, you cannot reference specific users within the Users list as this is production data, which can change and make your formula invalid.
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]
