3 Replies Latest reply: Jan 24, 2013 10:26 AM by OBID3

# Finding out the percentage  from 2 different reports

Hello Friends,

I am using OBI 10g. I am trying to divide values from one report which has a total count with another report which has a count with a particular criteria. For example, one report has count of people living in various states and the other report has a count of people who are above 60 years living in those states. Now I want to calculate the percentage. Say 80 people are living in Florida and number of people over 60 years living in Florida is 40, so I have these 2 reports already on my page. I want a 3rd report which gives the % of these two reports ie (40/80)*100 = 50. I want to use this 3rd report on the same page. Please let me know how to accomplish this. Also, let me know if you need any other information.

Thank You.
• ###### 1. Re: Finding out the percentage  from 2 different reports
Try using Criteria tab->Column->fx->Filter
try to build other 2 reports criteria so that you get the value as expected

Something like
FILTER(Fact."# People" USING ( people over 60 years living in Florida))/FILTER(Fact."#People" USING ( people living in Florida))*100.0

Edited by: Srini VEERAVALLI on Jan 17, 2013 6:12 PM
• ###### 2. Re: Finding out the percentage  from 2 different reports
Hello Srini,

Thank You for the reply. Here the report for people over 60 years living in Florida is the result of combination of 6 reports (*using combine with another request*). I am not able to figure out how to pull people over 60 years living in Florida and
people living in Florida in the below formula
FILTER(Fact."# People" USING ( people over 60 years living in Florida))/FILTER(Fact."#People" USING ( people living in Florida))*100.0

It will be helpful if you can advice me in this regard.

Thank You
• ###### 3. Re: Finding out the percentage  from 2 different reports
I would suggest to do start with 1 or 2 reports, if that works then expand it for all reports.
If you do all at once you might end up with issues and frustration :)