Filter numeric datatable column by negative number does not work

[Brent]

I have a datatable with a column that is numeric and has negative and positive numbers. I am using the native filtering. If I try to filter by a negative number it does not filter the data. For example
“> -1000”. If I filter by a positive number it does work. For example < 1000. Why do negative numbers not work?

[stu]

just >-1000

[Brent]

I am not using quotes in the code. I had to put them in the question otherwise the markdown takes the greater than as a block quote.

[stu]

Fine. Please follow this below.

How to write a Minimal Reproducible Example (MRE)

Adding a minimal reproducible example to your questions will help attract community members to answer your question. The goal of writing a MRE is to allow other members of the community to run the code on their computers and “reproduce” the error, so that they can best help you. Please make sure that your MRE includes data and that the code is correctly pre-formatted. To preformat, copy and paste the code in your post and then click on </> (Preformatted text), as shown on the image: [pre-for…

[dgudhka]

I have a dash table and when I try to sort data, it does not do it right for negative numbers. Any idea on what part of the code may need to be investigated?

[stu]

hi @dgudhka , have you tried the brand new component dash-ag-grid?

Dash AG Grid | Dash for Python Documentation | Plotly