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

    Finding out the percentage  from 2 different reports

    OBID3
      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.