Rank in Text Box

[#1]

Hi

How can I display the rank  in a text box   of a selected value  from a list box ?

Suppose I have this input data

Id   Value

1    100

2    10

3    500

If I selectec   Id=1  I   want to display in the text box Rank = 2

Regards

JJ

[swuehl · Accepted solution]

Try

= 'Rank = ' & aggr( if(d=GetFieldSelections(Id),rank(sum({1} Value))),Id)

[#3]

Thanks Stefan

It works also without the GetFieldSelection :

= aggr(  rank(sum({1} V)),Id)

JJ