Difference between two variables from two different tables

[Altair]

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?

[Nuke354]

You could use one or more SELECT statements by separating them by parenthesis

 

Example: (Select)-(Select)

[Barbie]

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

[Barbie]

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