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.
ROBOTIKER
Date
Votes
2 comments
-
Jet Reports Historic Posts I am not sure if this is the answer you are looking for but I have attached an example of how you can do math with Jet Reports. I hope this helps!
-
Jet Reports Historic Posts Thanks a lot.
Your answer is quite near to what we need. We wanted to get the total sum for all products in a cell, without listing them, but finally we have made an auxiliar and not visible sheet, and get the total in our cell.
We are new in JetReports, so all the community help is very useful for us.
Thank you.
Please sign in to leave a comment.