Jump to content
Sign in to follow this  
pjp

Rank of record in a table calculation

Recommended Posts

I have a table of companies and a field in that table for the number of patents that the company has received in recent years.

I want another field that calculates the rank of this particular company amongst companies in the table according to the number of patents it has received. i.e. the company with the most patents would be ranked 1, that with the second largest number of patents would be ranked 2, etc.

I would like the calculation to update when a new company is added to the table and to be available in a variety of layouts and contexts.

I figured that I could add a self-join relationship on the number of patents field with an inequality (i.e. to relate to all companies with patents greater than or equal to the patents of this company) and then use a count function; however, I was looking for a way that would not require me to add a new relationship, and hence would not be layout/context dependent.

Any ideas would be greatly appreciated.

Share this post


Link to post
Share on other sites

I was looking for a way that would not require me to add a new relationship, and hence would not be layout/context dependent.

I don't think you need to worry about that. The calculation will be evaluated from the context of the table set in the 'Specify Calculation' window, and it will return the same result in every layout.

Share this post


Link to post
Share on other sites

Thank you.

I just implemented this and it works perfectly.

You have made my day.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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