10 Replies Latest reply: Apr 12, 2016 3:58 PM by Saran De

# Use Only Function with Rank

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!

• ###### Re: Use Only Function with Rank

hi,

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

• ###### Re: Use Only Function with Rank

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

• ###### Re: Use Only Function with Rank

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

• ###### Re: Use Only Function with Rank

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

• ###### Re: Use Only Function with Rank

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

• ###### Re: Use Only Function with Rank

How do you determine rank?

• ###### Re: Use Only Function with Rank

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

• ###### Re: Use Only Function with Rank

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)

• ###### Re: Use Only Function with Rank

Only({<Field1={"=Rank(Field1)=2"}>}Field1)