Filter not working as needed

[_JAA_]

Hi,

I need to filter a column to pull through only:

< .6

when I look at the data, even though I don’t have

<= .6, i’m still pulling through .6. 

type of data in column: V_String

How can I rework this to exclude .6? 

thank you

[OllieClarke · Accepted solution]

Hi @_JAA_ 

If you want '<' and '<=' to work as less than, or less than or equal to, you'll have to apply them to a numeric field. Your field is currently a V_String (or text based field), but if you change it to a double (for instance), then your filter of [Field]<0.6 should work

Hope that helps,

Ollie

[Martyn]

Use ToNumber([Field]) < 0.6 in your filter.

[_JAA_]

I had tried this prior to posting with no success. I’m sure I overlooked something. But it worked this time! Thank you-