Calculate a cell from two different tables

I need to calculate, in a cell, the total sum of the multiplication of the Amount of the table FA Ledger Entry and the Pct Subvencion, new decimal field we have added to the Fixed Asset table. I know I can use a list in other sheet and get the total, but I can´t use other sheets.

I know how to do it in SQL, another posibility is using the SQL option of NL, but it doesn't work, it says me "SQL table not found".

The SQL instruction I need to use is

SELECT SUM(A.amount*B.Pct Subvencion) FROM FA Ledger Entry A, Fixed Asset B WHERE
A.FA No. = B.No.

Thank you very much in advance.



Please sign in to leave a comment.