Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[amiti]

Hello , I am using MC 18.201

I created a math expression field in the library by calculating [number of plays]* [rating] / [age] . I took into account the formatnumber() problem and succeeded eventually to get the wanted results. The problem though is in the auto playlist creator. When sorting that field in ascending order all is going well but sorting in descending order give weird results. I tried turning the number to integer by multiplying it or padding it with zeros but nothing seem to help.

Is it a bug or am I doing something wrong?

Thank you.

[MrC]

Some comments:

I've reported several sorting issues, but don't know if this case is the same

Is the expression field an Integer or Decimal field, or did you cast the expression to either of these?

Can you share the screenshots so we can see what is happening.  Minimize the number of entries just enough to show the problem.

[amiti]

Thank you for your help.

I added data type and formatnumber() to whereever might be a problem. It seems to work now correctly.

Maybe the problem lies with the calculations delay which cause weird results in smart playlists if you change expression fields too quickly?