 Help Needed in Oracle Discoverer [message #147428] |
Thu, 17 November 2005 10:00 |
sourajit_seth
Messages: 38
Registered: November 2005
Location: India
|
Member |
|
|
Hi,
I faced problem while generating one discoverer report as follows,
Resolved Closed
----------- --------
Type A
Problem1 30 40
Problem2 10 20
Total 40 60
All Type
Problem 1 20 30
Problem 2 30 60
Problem 3 100 80
Problem 4 50 130
Total 200 300
Percentage 20% 20%
Total is calculated using "Total " Tool available in Discoverer Report for each change in left most column. But now I have to calcutate the percentage of (40/200 * 100) and (60/300 * 100) , i.e. I have to show 20% and 20% as mentioned above.
How shall I show,
I developed the full report except percentage portion.
There are 4 fields in query , Type (Type A, Type B ..),
Problem (Problem 1, Problem 2 ...),count(Resolved), count(closed).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
