Simple Ranking

[LOUM]

ok this is driving me nuts!     :o

List report.
Rank([QTY])

Why are my results skipping numbers (Ranks)?

Data looks like this when it runs.
Rank - Qty
1 - 117
2 - 95
3 - 92
3 - 92
5 - 89
5 - 89
6 - 85
6 - 85
6 - 85

[blom0344]

ties yield equal ranks
Ye average modern database has a dense_rank function to eliminate gaps,which would yield:

1 - 117
2 - 95
3 - 92
3 - 92
4 - 89
4 - 89
5 - 85
5 - 85
5 - 85

[LOUM]

Blom,

Thank you for the reply, unfortunately it is slightly greek to me. Is dense_rank a correct function in C8?? or is it another function. If I am understanding you correctly it would be written like like this

dense_rank([QTY])

Thank you!

[blom0344]

Cognos supports the use of native functions (make sure you enable them in the package def). The latest database versions support dense_rank() function, but you need to try and find out if thse can be used from within Cognos

[LOUM]

Thank you everyone for your wonderful support.

Lou