• 0

# Total Records In A Table

## Question

Hi all,

Is it easy to calculate the total number of records in a table to display on a data page?

I was thinking of creating a landing page with summary data on it including some record totals.

Thanks!

JC

## Recommended Posts

• 0

Hi, yes, it's very easy.

You should add "Totals and aggregation" to your report. You can read more here

Also if you're interested in advance reporting you can find a video and articles here

• 0

Thank you!

##### Share on other sites

• 0

Do these calculations require the paid version of Caspio? I've been looking all over for this in my tabular report and cannot find it anywhere!

Also, if so and need to upgrade, can I pass the calculated value into one of my datatables?

##### Share on other sites

• 0

I think it is only available for paying accounts. You may check their pricing plan here:  https://www.caspio.com/pricing/standard-edition/ and try to find Formulas and Calculations.

To your second question, yes you can pass your Calculated Value. You may set this as one of your fields in your table.

I hope this helps!

##### Share on other sites

• 0

If you use Calculated field or value in this case, than you can use this formula to display the total number of records in your table:

`SELECT COUNT([@field:ID]) FROM tablename`

Please change the field:ID to your actual unique-identifier field and the tablename to the actual table you wanted to get the total of records.

For more information about the formula function you can use in the calculation, check out this documentation:

I hope this helps

~WatashiwaJin~

##### Share on other sites

• 0

The SQL COUNT() function returns the number of rows in a table satisfying the criteria specified in the WHERE clause. It sets the number of rows or non NULL column values. COUNT() returns 0 if there were no matching rows. The above syntax is the general SQL 2003 ANSI standard syntax.

##### Share on other sites

• 0

Yes, you can create a details page based on the same table. Add calculated fields and use SQL syntax to create the dashboard. For instance:

SELECT COUNT(Record_ID) FROM table_Name

##### Share on other sites

• 0

While it is true that you can use SELECT Statements for this. I think it is also doable using Pivot tables, wherein you can easily select Value then use summarize values by Count. You can refer to this link.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.