Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
2 years ago

Limit # of records in a table report

I'd like to be able to run a report that shows just the top 20 results. For instance, customers - sorted by volume from largest to smallest, only returning the top 20. I can't seem to figure out how ...
ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
2 years ago

Here is my formula: (64 is the FID for "Total Won Value (YTD)" and 62 is the FID for "Territory")

var text QUERY = "{64.GT.'" & [Total Won Value (YTD)] & "'}AND{62.XEX.'Knoxville'}";

Size(GetRecords($QUERY))+1

Here's the results I'm getting:

As you can see it's not sorting by that field at all. Also it returned 32 results for #s up to 15 and none of the numbers match.


------------------------------
Thanks,
Chris Newsome
------------------------------
MannyPinheiro's avatar
MannyPinheiro
Quickbase Staff
2 years ago
What result are you getting? Or what's not working as you expect it to?


  • ChrisNewsome's avatar
    ChrisNewsome
    Qrew Captain
    2 years ago

    did you see my post above with the photo?



    ------------------------------
    Thanks,
    Chris Newsome
    ------------------------------
    • MannyPinheiro's avatar
      MannyPinheiro
      Quickbase Staff
      2 years ago
      First, can you change the operator from GT to GTE. 


      • ChrisNewsome's avatar
        ChrisNewsome
        Qrew Captain
        2 years ago

        Will that correct it? I did that based on what she said in the video.



        ------------------------------
        Thanks,
        Chris Newsome
        ------------------------------