Unfortunatly there is no "like" available.
The avilable Operators are: (in addituon to =, <> etc)
All And Between Block Body Bottom Break Col Distinct ForAll ForEach In IncludeEmpty InList Not Or Reort Row Section Self Top Where
Sorry I didn't expalin correctly:
In a Query, of course, you can use "Match" but on a variable in the Report of a "Wegintelligence" (BOXI Release2) Report Variable, seems that "Match" is NOT available. Isn't it?
How can I filter to A PART of the value?
Let’s say the field values are
“One Alpha”
“One Beta”
“Two Alpha”
“Two Gamma”
and I would like to find all values CONTAINING “One”
I know the Operator “InList” (see example below):
=If([Query1].[Field1] InList("One Alpha";”One Beta”;"okay”;”Not Okay”)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.