Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Percentage of totals column at Answers

717646Oct 25 2010 — edited Oct 25 2010

Hi Experts,

Facing a strange issue as described below:

I have 4 columns in my report:

Quarter Quantity Total Quantity %ge
06Q2 7326 8,280,888 100

I calculated % = Quantity/sum(Quantity) * 100 but getting %ges as 100% in all the rows which is exactly wrong.

Please suggest how to get the correct results?

Thanks
Meera

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2010

Added on Oct 25 2010

#answers, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #in

10 comments

615 views