Altair Posted August 9, 2019 Report Share Posted August 9, 2019 I would like to find the difference between two variables from two different tables in a calculated field. How can I use multiple SELECT statements? Quote Link to comment Share on other sites More sharing options...
0 Nuke354 Posted August 9, 2019 Report Share Posted August 9, 2019 You could use one or more SELECT statements by separating them by parenthesis Example: (Select)-(Select) Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted August 16, 2019 Report Share Posted August 16, 2019 Hi, Just to add some information, I suggest create a calculated field and create a SELECT statement where you will get the values from the other table and then subtract the other field. Here's a sample select statement: ([@field:Payment]) - (SELECT Paid FROM tbl_2_2 WHERE Customer_ID=target.[@field:Customer_ID]) Hope this helps. -Barbie Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted August 16, 2019 Report Share Posted August 16, 2019 In addition to that, you may want to check out this article: https://howto.caspio.com/function-reference/ Just scroll down to Subqueries in Calculated Fields Thanks Quote Link to comment Share on other sites More sharing options...
Question
Altair
Link to comment
Share on other sites
3 answers 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.