How to display max of value into Text Box...

[#1]

Hi All,

I have One filed, For Ex,  filed Name Called ID ,

ID

---

1

2

3

4

5

6

7

8

9

10

....

here i want display max(id) and min(id) into different two text box(or table box) same time and suppose when i am select any ID(1 or 2) it won't be change that text box value(For Ex ,Max ID is 10, Min ID is 1) it's static and display text color value maximum value is GREEN and minimum value is RED.In that text value directly pass the two input box.how to do it?  i try to write using set analysis($) function but its failed. please help me this.

Regards,

Raja.

[#2]

Hello Raja,

You can do this to get the max and min of ID,

=Max({<ID>}ID) for max

=Min({<ID>}ID) for Min

Hope this helps.

Thanks & Regards,

Venkat T

[#3]

=max({<ID= >}ID)

=min({<ID= >}ID)

Hope this helps.

regards,

MT

[nizamsha]

PFA

[#5]

You forgot the equal (=) sign.

regards,

MT

[#6]

Thanks to all...

[#7]

Hi All,

i want to display max of fifth ID into text box , i try to write below syntax but it's failed.Rank function not list out our text box.Please help me how to display top values into text box.

=Aggr(if(rank(ID)>=5,ID),ID)

=if(rank(ID)>=5,ID)

Regards,

Raja.

[#8]

I dont really understand your problem could you give an example please.

regards,

MT

[#9]

Hi,

Add 2 text fields, open the propertiy window of text max and in thext type it as =MIN(fieldname)

[#10]

Hi KBS_Tamm,

Thanks for your quick response,

I  have One filed, For Ex,  filed Name Called ID ,

ID

---

1

2

3

4

5

6

7

8

9

10

i want display top five values(For Ex : 6,7,8,9,10 using rank function ) into one text box.

Regards,

Raja.