Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Can we sum two different values from different data sets in BIRT??(Need aggregate values from two different data sets)
Can we sum two different values from different data sets in BIRT?? [message #1793355] Mon, 06 August 2018 11:11
Jithendra Reddy is currently offline Jithendra ReddyFriend
Messages: 1
Registered: August 2018
Junior Member
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.


Previous Topic:SuccessFactors reusing custom fields
Next Topic:BIRT 4.6.0 on Maven ?
Goto Forum:
  


Current Time: Tue Apr 23 13:51:10 GMT 2024

Powered by FUDForum. Page generated in 0.03067 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top