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 calculation in answers

user1740166Apr 23 2010 — edited Apr 27 2010

I have to calculate the % values. I used sum, rsum and % to achieve this. But for some reason I am not able to get the % going.

Here is my table with three columns (Used Bin in answers for this requirement)

# Days # Persons % Persons
--------------- -------------- --------------
< 5 Days 14,090
5-10 Days 1,486
31 + Days 5,241
21-30 Days 792
11-20 Days 1,173
----------------------------------
Total 22782
---------------------------------

In the new column % Persons, I am looking to calculate % Persons based on the value in # Persons.

I want to calculate % Persons for 14,090 as (14,090/22782) * 100 and rest follows.

I have been using this in the column % Persons formula and getting the values as 0.

#Persons/sum(#Persons)*100

Any help with this is really appreciated.

Thanks/

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2010

Added on Apr 23 2010

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

6 comments

1,788 views