How to Calculate Rank from expression..

[#1]

Dear friends,

I need to calculate the Rank from the expression (here i need to calculate from expression only, not from the source field and also it shouldn't be calculated in the script).

I have attached the QVW file please let me know if anyone can help me here.

Regards,

Pooja

[Anil_Babu_Samineni]

What are you expecting?

Usually, we can calculate Ranks are like below

1) Rank(Expression)

2) Set Rank

3) From script you can try this too

if(Expression=previous(Expression),peek('Rank')+1,1) as Rank

[Kushal_Chawda]

use below expression

=rank(total sum(if(Dept='Sci' and Subj = 'science', Amount*10,

if(Dept='Sci' and Subj='chemi', Amount*5,Amount))),0,1)