Multiple filters using StartsWith

[bui195]

I'm trying to filter out data set with GL accounts that start with number 17 and 30 (GL accounts have 6 characters). So far I can only filter dataset with 17 GL or 30 GL. Can I write one formula that apply to both numbers? Thank you. 

[ShankerV]

Hi @bui195 

Please try using the OR function.

[ShankerV]

Hi @bui195 

One way of doing this, 

left(tostring([GL accounts]),2) = "17" OR
left(tostring([GL accounts]),2) = "30"

Many thanks

Shanker V

[NMangera]

@bui195 ,

if the data type is already a string, another approach is...