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.
Sum of total columns from different data sources
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Sum of total columns from different data sources
- Attachments
-
- 2.JPG (39.77 KiB) Viewed 1799 times
-
- 1.JPG (119.31 KiB) Viewed 1799 times
-
- soma rodape.mrt
- (11.34 KiB) Downloaded 156 times
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Sum of total columns from different data sources
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.
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.