Calculate the columns with different tables.

[Nandhini-Kumaresan]

Hi,
I want to calculate the columns from different tables. For Example, I want to divide the total customer_id column of sales table with total customer_id column of customer table. Is that possible to do the calculation in the Add Calculate field or Add Measure?

[tvc12]

Hi @Nandhini-Kumaresan,
Add Measure field is a answer for this question. Calculated field work only in one table.

[tvc12]

Please replace [ and ] by empty string and try again. That is a problem when create measure field. We will release fixed in next release.

[Nandhini-Kumaresan]

Hi @tvc12,
I tried replacing [and] with an empty string, still i am getting the error.

I used dbname.tablename.columnname to define a different table column. Is this the one that should be used?

[tvc12]

try with expression below:

count(entity_id) - (select count(mysql_db.sales_order.customer_id) from mysql_db.sales_order)

If it's not work, use can create view table by using Query Analysis. Following step 6 in documentation in here

[Nandhini-Kumaresan]

Tried the given expression, it shows error.

Will try to create view table using Query Analysis and let you know.

[tvc12]

Hi @Nandhini-Kumaresan ,
Message error: Missing columns. Please check column names and try again.

[Nandhini-Kumaresan]

Hi @tvc12 ,
The column name is exist but in another table.