This discussion is archived
3 Replies Latest reply: Jan 24, 2013 8:26 AM by OBID3 RSS

Finding out the percentage  from 2 different reports

OBID3 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points