1 Reply Latest reply: Apr 2, 2014 12:01 AM by Ram.. RSS

    Grandtotal Issue for percentage columns

    ashwini_406

      Hi,

       

      We are using obiee 11.1.1.6.6  I have one percentage column. c % = 100*(a /b)

      My result set :

       

                    a    b     c

                    0    2     0

                    2    2     100

                    0    4     0

      G.Total:   2    8    0

       

      I need to get 25%  (100*2/8), but I'm getting wrong grandtotal for percentage columns. I tried server complex aggregate, but still getting 0.

       

      Please help me on this issue. Any suggestions?

       

       

      Thanks