Skip to main content
Question

Limit # of records in a table report

  • November 29, 2023
  • 0 replies
  • 361 views
Forum|alt.badge.img+10

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 to limit the results - i'm getting every customer in the system. Any help?



------------------------------
Thanks,
Chris Newsome
------------------------------
Thanks, [FirstName] [LastName] [Designation] [JobTitle] [CompanyName] [City] [State] [Phone]

    • MannyPinheiro
    • Quickbase Staff
    • November 29, 2023

    You can use a formula query with the Size function in a report formula to evaluate the field containing the volume data to check if it is greater than or equal to the volume. The size will return how many records you have by volume and assign a numeric value. You a filter the report to only show records where size is less than or equal to 20. 

    However, if you have many records that equal the same volume you will have many records with the same size value. 


    Terms & ConditionsAccessibility statement