Filtering on decimal values

[jjimenez]

Hello!

Is there a formula I could create in the filters tool or other tool that can extract from a large database decimal values that end in $x.19, $x.25, $x.29, $x.35, and $x.39?

(i.e. $1.19, $2.25, $2.29, $3.35, $5.39, etc.)

Any help with this will be greatly appreciated. 

[alexnajm · Accepted solution]

EndsWith(ToString([Data],".19") OR EndsWith(ToString([Data],".25") and so on should work

[OTrieger]

@jjimenez 
In the Custom Filter you can use REGEX so if the above will not work you can try REGEX match

[CoG · Accepted solution]

Similarly, you can use Right([Data],3) in (".19", ".25", ".35", ".39")