3 Replies Latest reply on Jan 24, 2013 4:34 PM by SriniVEERAVALLI

# 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