Table list view: Sorting integer column by descending/ascending is showing unexpected results

[Cris P]

Hello everyone,

I have a bit of a weird one and am wondering if anyone has come across this issue.

I have a scoped table, with a column of type integer (The column has a calculated value):

When i sort the column by ascending, I get this:

When I sort the colum by descending, I get this:

As you can see above, the number do not sort properly; I have checked the type of the values (using the typeof built in JS function) and they are all of type number... Any kdeas why they do not sort correctly?

[Community Alums]

Hi @Cris P ,

Refer to this Support KB: List sorting is not working on a particular table on all the columns.

Also, try the below things :

Try to close your browser and restart, clear all your browser caches and re-try.

Is there any Queries underlying sets the order/Sort.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Hi @Cris P ,

Glad to see my answer helped You. 
Kindly mark the applicable answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Muhammad Khan · Accepted solution]

Hi,

You might find this reason helpful.

Sorting of a calculated decimal field fails in list