Forum Discussion

igaca's avatar
igaca
Icon for Helper III rankHelper III
8 years ago

EARLIER and calculated column value return

I am trying to get a "ranking" based on the order of appearance of select values in a table, as determined by certain other criteria within that table (Ref. to "Dwg Nth Occurrence (IFC)" column (far ...
Need Help
Tutorial Requests
igaca's avatar
igaca
Icon for Helper III rankHelper III
8 years ago

Let's phrase this another way: 

 

when using EARLIER to derive an order based on some numerical value (a date or a unique set of numbers), how would one go about breaking any ties within the "rank value" (in this instance a date value)?

igaca's avatar
igaca
Icon for Helper III rankHelper III
8 years ago

Does anyone have any thoughts?

 

Again, the issue is how to break ties when ranking values based on their date order when two or more of those values have the same date.  If you think you have some ideas on how to address, please chime in.

 

I've tried a multitude of approaches including the use of RANKX without success.

 

Thanks in advance!