guardmetrics Posted December 30, 2019 Report Share Posted December 30, 2019 I'm working on putting a formula field in my table that will count all records in a separate view. (i.e. Subscribed Users = # of records in a filtered view If someone could point me in the right direction for this CASE statement, that would be amazing!! Quote Link to comment Share on other sites More sharing options...
0 Vitalikssssss Posted January 1, 2020 Report Share Posted January 1, 2020 Hi @guardmetrics, Formula field performs calculation within a record and it cannot be used for cross table calculation. You should consider using Calculated fields on Report/Details datapages with SQL in order to perform cross-table calculation. Here is an article which explains how to use SQL in Calculated fields: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ You may use Task/Triggered action feature if you would like to store value of cross-table calculation on table level. Here is an article: https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps. Regards, vitalikssssss Quote Link to comment Share on other sites More sharing options...
Question
guardmetrics
I'm working on putting a formula field in my table that will count all records in a separate view.
(i.e. Subscribed Users = # of records in a filtered view
If someone could point me in the right direction for this CASE statement, that would be amazing!!
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
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.