Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Percentage calculation between cross tabs
Migrateduser
<p>Hello</p><p> </p><p>I am working with BIRT since 4 months (I am a business analyst and I do not code) and this forum has been very inspriring and helpful - thank you. However, this time, I did not find the solution for my problem which is the following. I need to create a report giving - per department - the percentage of people within the departement who have followed a traning. To do so, I am working with two dataset presented in cross-tabs:</p><ul class='bbc'><li>learning history</li><li>total population</li></ul><p> </p><p>As the two datasets are different ones, I am calculating the percentage by putting in the script on "on create" the following <em>reportContext.setGlobalVariable("Fvorming",<strong class='bbc'>this</strong>.getValue());</em></p><p> </p><p>By doing so, I have only one record coming back as percentage, while I would like to be able to get as many values as there are rows in my cross-tab. Is there a way to do so.</p><p> </p><p>Thank you in advance for your help</p><p> </p><p>SD</p>
Find more posts tagged with
Comments
There are no comments yet