Jump to content
  • 0
Sign in to follow this  
AndrewCHughes

SELECT COUNT() possible?

Question

Is it possible to use COUNT(some_column) in the select field of a table query? I am unable to get it to work. Is there some other way to get a count of results without having to return all the results and count them?

Andrew

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0

You can use the SELECT COUNT in a calculated field in reports or details pages, but sub-queries are not allowed in formula fields (table based calculations).  What is the overall workflow you are looking to achieve and maybe I can help guide you to some other solutions?

Take a look at these links for some additional information as well:
https://howto.caspio.com/function-reference/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×