Parameter that Includes/Excludes Data that Contains Certain Prefixes

Question & Answer
, , , , ,
4

You can use a combination of “ifelse” and “contains”.

Something like:
ifelse(contains(“datafield”,‘NC’) = true AND (all the others),‘Yes’,‘No’)

See also Link