Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
hi,
=only({1<Rank(FIELD1)=2>} FIELD1)
chk dis
How you are deciding the Rank? what is the criteria?
How do you determine 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
When I put Rank = 2 i'm thinking about the second position (the first second position)
When I put Rank = 2 i'm thinking about the second position (the first second position)
I am still not clear. Can you show the sample data with expected output?
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)