Substring value condition | Custom filter

[Rmartinez]

Hey! 

I’m trying to apply a customer filter based a substring of a numeric id.

As I need to apply the ‘less than’ operator, I need both arguments to be numeric, allthough I can’t seem to convert the substring result to a number. ‘to_number’ and ‘cast’ functions are not working.

How can I fix this simple restriction?
 

Thanks in advance!

[Dawid]

That’s because your ID is probably of type:number. Try the following: