March 2018
Beginner to intermediate
514 pages
13h 11m
English
Operators are used to include, exclude, or intersect parts of or whole datasets. All operators use sets as operands and return a set as a result.
The following table shows operators that can be used in set expressions:
| Operator |
Description |
| + |
Union: This binary operation returns a set consisting of the records that belong to any of the two set operands. Example: count({$<Product = {"Current Account"} > + 1-$ <Year = {2018}> Distinct [User Id]) This example counts the distinct users of the product Current Account and also counts all the users of the set excluded by user selection for 2018 across all products. |
| - |
Exclusion: This binary operation returns a set of the records that belong to the first but not the other of the ... |
Read now
Unlock full access