Problem using table filter with number column in greater than

[zeroray]

I have a problem using table filter with number column in greater than

When I apply filter

The result is wrong

Can you help me please

[ScottR]

try putting a comma in the value like 9,000 and see what happens

[jonathanbredo]

Hey zeroray!
What is the win amount data type :-)? And where is it sourced from :-)?

Jonathan

[zeroray]

Datatype is string in Bigquery.

The table component in retool transform to Number

[jonathanbredo]

I think that might be the issue. If you CAST(column AS int) (ref:
https://cloud.google.com/bigquery/docs/reference/standard-sql/conversion_functions#cast), it should work :-).

[zeroray]

I will try and to respond you ASAP

[zeroray]

It's working now.
Thanks you.