Set analysis.....

[prabhas277]

Hi,

I have some fields in my list box,Those are like cricketes names. so now i want expression for max runs batsman and min runs batsman..how to write a set analysis expression ...?

Thanks In advance

[anbu1984]

If you already have aggregated Runs scored by cricketer, then try this

Max runs batsman

Firstsortedvalue(CricketerName,-Runs)

Min runs batsman

Firstsortedvalue(CricketerName,Runs)

[prabhas277]

Hi anbu,

i dont want like that ...i want  like set analysis experssion...

[anbu1984]

=MaxString({<Runs={'$(=Max(Runs))'}>}CricketerName)

=MinString({<Runs={'$(=Min(Runs))'}>}CricketerName)