Skip to main content

Set modifiers with advanced searches

Advanced searches using wild cards and aggregations can be used to define sets.

Examples and results:  

Examples Results
sum( {$–1<Product = {“*Internal*”, “*Domestic*”}>} Sales )

Returns the sales for current selection, excluding transactions pertaining to products with the string ‘Internal’ or ‘Domestic’ in the product name.

sum( {$<Customer = {“=Sum({1<Year = {2007}>} Sales ) > 1000000”}>} Sales )

Returns the sales for current selection, but with a new selection in the 'Customer' field: only customers who during 2007 had a total sales of more than 1000000.