Alessandro Posted January 13, 2022 Report Share Posted January 13, 2022 I need to calculate the ratio between the grand-totals from two different data pages How is it possible to do it? Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted January 14, 2022 Report Share Posted January 14, 2022 Hello @Alessandro, Could you specify the formula you need to apply and the DataPage type where you want to apply this formula? Basically, if you need to get data from 2 different tables, you may use a SELECT statement For example: SELECT Count(Country) FROM Customers WHERE Country=’Canada’ You may want to check this article https://howto.caspio.com/function-reference/ If you use different tables to build these 2 DataPages, you may join them in the View and use this View to create a DataPage https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/ I need to have more details to provide you with a formula. Quote Link to comment Share on other sites More sharing options...
Question
Alessandro
I need to calculate the ratio between the grand-totals from two different data pages
How is it possible to do it?
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.