StartsWith funciton not working as expected

Question

Im trying to exclude some dummy active directory accounts that have been setup in the past.... They all start with bl and I thought I could use the filter tool with StartsWith('bl', [identity]) but this doesnt exclude them, if I put in the full name of one of the accounts it picks it up though, its like I need 'bl*' as a wildcard or something

alexnajm · Answer

If you want the filter to EXCLUDE those that start with bl, the filter logic should be !StartsWith([identity],”bl”)and seeing the T anchor! Or StartsWith([identity],”bl”) and looking at the F anchor