| Can we sum two different values from different data sets in BIRT?? [message #1793355] |
Mon, 06 August 2018 07:11 |
Eclipse User |
|
|
|
Hi I am designing a learning transcript in BIRT, I have two different data sets learning and training. From learning data set I have total CPE hours and total CEU hours, And from training data set I have total training hours.
Now I wanted to have grand total as sum of total learning hours (Total CPE hours and Total CEU hours) and Training hours. Since these two values are sitting in different data sets, is there any way that I can sum of Total CPE Hours, Total CEU Hours and Total Training Hours from different data sets learning and training as specified above.
Example
Learning Course Class Name Location CPE Hours CEU Hours
Course 1 Class 1 New York 2.00 3.00
Course 2 Class 2 New York 1.00 2.00
Course 3 Class 3 New York 2.00 1.00
Total Learning Hours 5.00 6.00
Training Course Training Class Location Training Hours
Training Course 1 Training Class 1 New York 1.00
Training Course 2 Training Class 2 New York 2.00
Training Course 3 Training Class 3 New York 1.00
Total Training Hours 4.00
Grand Total of Learning and training Hours (CPE Hours + CEU Hours + Training Hours ) = 15.00
Any corrective input on this is highly appreciated.
Do let me know for any additional information if needed on this.
|
|
|
Powered by
FUDForum. Page generated in 0.03858 seconds
Home