Use Only Function with Rank

[#1]

Hi experts,

How can I show only the Field with rank = 2?

I'm trying with this expression but it give me an error (bold)

=only({<Rank(FIELD1)=2>} FIELD1)

I'm trying this in a text object!

Thanks!

[Chanty4u]

hi,

=only({1<Rank(FIELD1)=2>} FIELD1)

[Chanty4u]

chk dis

How to use - Only()

[Kushal_Chawda]

How you are deciding the Rank? what is the criteria?

[sunny_talwar]

How do you determine rank?

[#6]

Hi Chanty 4u,

Thanks for your response but it still give me an error The datetype of my field is time, I don't know if it have any value to this

[#7]

When I put Rank = 2 i'm thinking about the second position (the first second position)

[#8]

When I put Rank = 2 i'm thinking about the second position (the first second position)

[Kushal_Chawda]

I am still not clear. Can you show the sample data with expected output?

[sunny_talwar · Accepted solution]

But on what basis? Second highest value in Field1?

May be this:

Only({<Field1 = {"$(=Max(Field1, 2))"}>}Field1)

or

Only({<Field1 = {"$(=Max({1}Field1, 2))"}>}Field1)