Wildcard in an IN formula

[dfloydnike]

I tried the below but it is not giving me my 2021 seasons:

[Season] in ('2017FA','2017HO','2018SP','2018SU','2018FA','2018HO','2019SP','2019SU','2019FA','2019HO','2020SP','2020SU','2020FA', '2020HO','2021**') 

I ended up using a starts with: 

[12:11 PM] Floyd, David

startswith([Season], '2021') or startswith([Season], '2021') or startswith([Season], '2020') or startswith([Season], '2019') or startswith([Season], '2018') or startswith([Season], '2017')

BUT I would think there would be a way to say find all seasons that begin with a string.

[Blake · Accepted solution]

Hi @dfloydnike - try the attached filter, it should do what you're looking to accomplish if you just want strings that start with "20xx"

[RWvanLeeuwen · Accepted solution]

Hi @dfloydnike 

I agree with the setup @Blake has provided. Please mark it as an accepted solution if this helped to resolve your case, so others can find it as well.

Best,

Roland

Infotopics - Benelux partner of the year

Empowering business through analytics. See, Understand, Act!