Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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