Jump to content

Highlight top 3 values


This topic is 2690 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Whats the quickest way to do this I'm having a mental block!

6 Fields in a record, each field contains a number, how can I use conditional formatting to highlight the top 3 Values?!?

Eg:

Field1 Field2 Field3 Field4 Field5 Field6

23       25        21       28       20       90

 

Highlight Fields 2, 4 and 6

 

 

Edited by liltbrockie
Link to comment
Share on other sites

conditional format, calculation with a Let() that does this:

 

- use List(Field1 ; Field2; ... ) to create a list in a calc variable

- use any of the custom functions to sort the list

- then an evalation wither self = getvalue( sorted_list ; 1 ) or self = getvalue( sorted_list ; 2 ) or self = getvalue( sorted_list ; 3 )

 

 

As an aside: when you start using sequentially numbered fields, it usually means there is need to break that out into a related table.

 

  • Like 1
Link to comment
Share on other sites

This is going to be awkward any way you look at it, because Filemaker has no mechanism for sorting fields. Obviously, these values should be in individual records of a related table - and I am not saying this as an aside. Even a repeating field would be better than 6 individual fields.

If I had to do this with your current structure, I would compare each field with all its 5 siblings, e.g. Self > Field 2, Self > Field 3, etc. Then, if 3 or more of these comparisons returned true, the field is in the top 3 (leaving aside the problem of ties).

Edited by comment
  • Like 1
Link to comment
Share on other sites

This topic is 2690 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.