Implementing a stack rank function?
I need to implement a stack rank of a list of items in a quickbase table. Is there a way to write a formula to update all records stack ranks when the value is set for a new item?
Forum Discussion
Summary reports can essentially do ranking because if you do a summary report but basically break on every record, you can have a field with a formula value of 1 and display that as running totals down the page. So they self number from 1 to .. whatever.
Hey so I am trying to rank based off of a calculation. My calculation returns a value (i.e. 100,115, 50,000, 10,000, 2103) I want those values ranked 1 through 100 based Highest to lowest. For example, 100,115 would equal 1 and 2103 equals 100, if there were 100 records.