Forum Discussion
The Size(GetRecords is the current method that I would recommend similar to the others in this thread. Again - I tried just using the Record ID# to fake a ranking value and I couldn't get it to work either so something is off I believe.
Depending on what you need this report for - you can use the API and do your own query - https://developer.quickbase.com/operation/runQuery - there is a parameter for options where you can set the 'top' and return only the number of records you want. This only works if you were doing a code page or trying to export/create a CSV, but an option nonetheless.
------------------------------
Chayce Duncan
------------------------------
I appreciate the info. The goal is to make a report for the Sales dept that they can run on demand to see who our top customers are. I'm actually comparing their volume from this year to last year. Everything on the report is fine, I just don't need 300 results... just the top 15-20. The ranking formula attempted in this thread was done as a report formula instead of a field itself based on the earlier replies about slowing the system down. So the goal is something that can be run with one click, easily, by a standard user of the app, so I don't think the other options you outlined would work.
I go back to my earlier comment - I can't believe it's not just a standard option to limit results to X number. Seems so basic.
------------------------------
Thanks,
Chris Newsome
------------------------------