Page 1 of 1

Sum of total columns from different data sources

Posted: Thu Oct 21, 2021 6:13 pm
by Manuel Costa
Gentlemen, I'm performing the following process I have two different data sources Folder and Report that have two columns of type Double, I total them with the SUM function and the result is returned normally.

But when I try to perform the REPORT_ID column of the double type of the Report source with the FOLDER_ID column also of the Double type and the Folder source, where it should display the total value, it doesn't return any value, Could you explain to me how I can perform this process?
Attached prints and the report in question.

Re: Sum of total columns from different data sources

Posted: Fri Oct 22, 2021 7:43 am
by Lech Kulikowski
Hello,

Please read the descriptions of the Sum function, it is not possible to use two columns in one function. You should use the following expression:
{Totals.Sum(FONTE, FONTE.FOLDER_ID) + Totals.Sum(FONTE2, FONTE2.REPORT_ID)}

Thank you.