| Want to Calculation based on Summary item [message #595156] |
Sun, 08 September 2013 01:07  |
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
|
Member |
|
|
See my data
Location--------Employee-------------Sales-----------------------Sales per emp
1------------------ 4-----------------------100------------------------------25
2------------------ 5-----------------------120------------------------------20
3------------------ 7-----------------------210------------------------------30
Total---------------16-----------------------430-----------------------------27
The total 27 achieve by (430/16)=27 How can I get using ORacle BI Discoverer 11g Desktop
please help
thanks in advanced
|
|
|
|
|
|
| Re: Want to Calculation based on Summary item [message #595203 is a reply to message #595201] |
Mon, 09 September 2013 04:46  |
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
|
Member |
|
|
Thanks for your reply sir
But How can i get this using Oracle Discoverer BI 11g
Bi giving mo option like
Sum
Cell Sum
Average
Count
Maximum
Minimum
Varient
When I put calculation it generate new Column like
Location--------Employee-------------Sales-----------------------Sales per emp New column
1------------------ 4-----------------------100------------------------------25 ???
2------------------ 5-----------------------120------------------------------20 ???
3------------------ 7-----------------------210------------------------------30 ???
Total---------------16-----------------------430------------------------------27
please help me how to get (430/16)=27
|
|
|
|
| Re: Want to Calculation based on Summary item [message #595207 is a reply to message #595203] |
Mon, 09 September 2013 06:10 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Few clarifications -
1. Is the sales per emp column rounded off?
2. How is the sales per emp for 2nd record 20 instead of 24?
To get the sum totals for emp and sales, you could get it by using SUM or CELL SUM function. But to do 430/16, you can't do it directly, you can only use these functions directly over aggregated values. What you need to do is, use AVERAGE function over the sales per emp column, which is nothing but average of 25,24 and 30.
|
|
|
|
|
|
|
|
|
|
| Re: Want to Calculation based on Summary item [message #595214 is a reply to message #595211] |
Mon, 09 September 2013 07:46 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
jainarayan5484 wrote on Mon, 09 September 2013 17:48yes it giving 25 not 27
You must be doing something wrong. Simple mathematics, with rounding off you should get 26(not 27, as 26.33 would be rounded off). If you are getting 25, it means you took the sales per emp value for 2nd row as "20" instead of "24".
Hopefully your issue is resolved, please recheck and let me know.
Regards,
Lalit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
