Bug of ordering mysql field column

[enishemed]

Dear Sergey,

I have a MySQL field column called "Birim Fiyat". I want to order by ascending or descending but it is not ordering correctly. Ypu can see from the pictures. It orders as a string not as a number.

Ordering is like this.

Ascending:
10
100
125
...
750
...
90

Descending:
90
85
750
70
67,5
....

[support]

it's because

67,5

is string, not number.

[enishemed]

67,5 is not a string, it is because of number format. You can see the number format from the screenshot. We use dot (.) for thousand separator and comma (,) for decimal separator.

it's because

67,5

is string, not number.

[support]

Then probably for some values formula return empty string or null. Formula should return 0 or other number.
I other case mysql will think it's string and values will be ordered as string.
Can you show me your formula?

[enishemed]

I have used IFNULL function in the formula and the problem exists.

Then probably for some values formula return empty string or null. Formula should return 0 or other number.
I other case mysql will think it's string and values will be ordered as string.
Can you show me your formula?

[enishemed]

I have changed the formula like this and the problem solved. Thanks.

Code: Select all

IF([797]=508,IFNULL([798]+0,0),IFNULL([799]+0,0))