Rank

[Anonymous]

Hi, how to calculate the highest rank and lowest rank in two separate text box?

[sorrakis01]

Resolve,

You have a DEPTNO  to NULL

Look the example.

Regars,

JAG

[#3]

see above... already uploaded named as 1000_calendar.qvw

thanks

[anbu1984]

Check the result of this expr

=Concat(DISTINCT Aggr(DEPTNO,DEPTNO) & ',' & Aggr(Sum(SAL),DEPTNO) & ',' &Aggr(Rank(Sum(SAL)),DEPTNO),Chr(10))

[#5]

Yes thanks alot

[sorrakis01]

Welcome

Close the discussion.

C y

JAG