How to sort by expression of a list box

[#1]

Hi all

Created an expression in list box:

=num(sum(if(Status='NPF',OS))/sum(OS

)*100,'0.0') & '%'

Trying to figure out how to sort the value descendingly

[nilesh_gangurde]

HI alex,

In properties => Sort=> check Numeric Value

or

num(sum(if(Status='NPF',OS))/sum(OS),'#,###%')

Then apply the above settings.

Regards,

Nilesh Gangurde

[#3]

Hi Nilesh

Use your expression which is better but the sorting does not work.

However I have figured out the solution - sort the expression.

Thks