I have a list in SharePoint online and I am trying to filter using the registration numbers and want to display all the registration numbers greater than 3000 (3001-3600) on a view. The total number of registrations(items) is 3600. When I filter the list saying Show items only greater than 3000, it displays all items from 3001-3600 but also displays registrations 1-999.
I have tried re-indexing the registration ID column.