Set modifiers with implicit field value definitions
The following describes how to define a set of field values using a nested set definition.
In such cases, the element functions P() and E() must be used, representing the element set of possible values and the excluded values of a field, respectively. Inside the parentheses, it is possible to specify one set expression and one field, for example
Examples and results:
Examples | Results |
---|---|
|
Returns the sales for current selection, but only those customers that ever have bought the product ‘ |
|
Same as above. If the field in the element function is omitted, the function will return the possible values of the field specified in the outer assignment. |
|
Returns the sales for current selection, but only those customers that ever have supplied the product ‘ |
|
Returns the sales for current selection, but only those customers that never bought the product ‘ |