Rank function

[knight_rider2905]

Hi I'm trying to use rank function on given below expression 

rank(avg( Col1)-fractile(Column2,0.9) * no. of orders ]

But it's returning all one values can someone please help me on how to apply rank expression to this function I need to resolve it urgently.

Thank you

[Ksrinivasan]

hi,

try this

=rank(((avg( Col1)-fractile(Column2,0.9)) * [no. of orders ]) 

ksrinivasan

[knight_rider2905]

Hi Srinivasan,

Thank you for reply but I want no of orders to be multiplied by
fractile(Column2,0.9) only but your expression is multiplying number of
orders by
(avg( Col1)-fractile(Column2,0.9)

can you pls look into it and let me know,

Thank you

[Ksrinivasan]

hi,

Fractile(Column(2),0.9) * ([no. of orders ]) 

ksrinivasan