Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsData Set Computed columns: Percentage
https://www.eclipse.org/forums/index.php/mv/msg/205975/659354/#msg_659354
I'm having problems when preparing the following report:
1 - I create a "data set" (Data set1) that returns the result of a select (count): 5
2 - I create a "data set"(Data set2) that returns the result of another count: 7
3 - I create a "Data set join" (Data set3) type "Ful Outer join" to unify both tables and working with them later.
4 - From the Dataset3 created earlier, try to add a column "Computed columns" to add the percentage. For this example, i created the following expression without any aggregation and citing the "Data type" float: (5 / 7) * 100
Can you comment on why the information does not appear aligned dataset3 and why not calculate correctly the percentage? Is there any other optimal way to plan and build this report with BIRT?
Thanks in advance.
Regards,
]]>Gin2011-03-12T17:53:28-00:00Re: Data Set Computed columns: Percentage
https://www.eclipse.org/forums/index.php/mv/msg/205975/659364/#msg_659364
Can you list the columns in each of your datasets? Also, full outer join may not be the correct approach - usually if you are going to do something like this you assume both datasets have values so an inner join would work.]]>Richard A. Polunsky2011-03-12T22:07:48-00:00Re: Data Set Computed columns: Percentage
https://www.eclipse.org/forums/index.php/mv/msg/205975/659427/#msg_659427
The result of "dataset1" is one column with the value 5, and the result of "dataset2"is one column with a single value: 7. If I do some "inner join " (or "cross join ") of both dataset, the result returned two columns are aligned but with value 35 each. It is clear that the problem is how to relate the two columns (which have no common field) to calculate the percentage then: (5 / 7) * 100. Can you help me build this select?
For any clarification or further information do not hesitate to contact me.
Thank you very much!]]>Gin2011-03-13T19:24:57-00:00Re: Data Set Computed columns: Percentage
https://www.eclipse.org/forums/index.php/mv/msg/205975/659489/#msg_659489
Gin2011-03-14T09:24:35-00:00