Ranking expression value

[jessica_webb]

Hi, I have a table with a few dimensions, and several expressions.

But, a basic version of the table is:

DIM - ID	DIM - Type	EXP - Avg(Score)	RANK
123	A	15.3	1/8
123	B	16.5	2/8
123	C	28.5	6/8
456	A	17	3/8
456	B	71.2	8/8
789	A	21	5/8
234	A	19	4/8
234	B	37.5	7/8

What I would like, is another expression that ranks the expression value, and tells me how many places it's out of - so the fourth column.

How would I do this?

[sunny_talwar]

May be this

Rank(Avg(Score)) & '/' & Count(TOTAL ID)

[jessica_webb]

No, that just gives me 1/8 for every value...

[sunny_talwar · Accepted solution]

My bad, try this

Rank(TOTAL Avg(Score)) & '/' & Count(TOTAL ID)

[sunny_talwar]

Or this

(Count(TOTAL ID) - Rank(Avg(Score)) + 1) & '/' & Count(TOTAL ID)

[jessica_webb]

Perfect - thank you very much