Search

x[ALL:y]

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

Back to Top

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]

Note that in this case ALL returns TRUE in the result for Birmingham and Lyon—this is because there are no selections for these cities in the Location source line item, that is formatted on the Organization list.

Back to Top

Similar functions