3 Replies Latest reply: Dec 26, 2012 12:05 AM by fiaz0419 RSS

    Issue with Sub total on Percentage column

    user8744765
      Hi Guru's

      i am having some problem on calculation subtotals on percentage column in OBIEE 11g

      I have a report like below, and i am doing total at product level , but the % column is not working as expected ,
      as shown below:

      Product     |       Total Amount        |       Total Margin         | Margin%(Total Margin/Total Amount 100)*
      P1                       100                                50                                     50%
      P2                      300                                100                                 33%
      Total                     400                               150                                 33%+(this should be 150/400 - 37.5% , but it is not doing the percentage based on totals and is picking some value from above values, either 33% or 50%)


      Can some one please help me with this.

      Thanks in advance...

      Edited by: user8744765 on Dec 16, 2012 9:38 AM

      Edited by: user8744765 on Dec 16, 2012 9:39 AM

      Edited by: user8744765 on Dec 16, 2012 9:43 AM