1 Reply Latest reply: Feb 12, 2014 11:07 AM by Raj2188 RSS

Wrong percentage in BIP Report

Alex1 Newbie
Currently Being Moderated

I have created an analysis in obiee (answers)

This analysis has one dimension of two elements (Public and Private) and 3 measures (actual, previous, %)

 

Then I have create a report on Publisher based in obiee answers analysis.

My report lookslike:

 

-------------Actual-------Prev------%

Private---100------------50--------100%

Public----200-----------75---------166%

TOTAL---300-----------125-------140%     <--- Correct value is 140% but when I show TOTAL on PUBLISHER I see sum of values (100+166=266%)


How can I fix this?

 

Thanks!

  • 1. Re: Wrong percentage in BIP Report
    Raj2188 Explorer
    Currently Being Moderated

    Hi Alex,

     

    Dont use supplied values, instead create a column in the report that calculates the %age and total for individual line.

     

    -------------Actual-------Prev------%

    Private---100------------50--------(Prev/actual)

    Public----200-----------75---------(Prev/actual)

    TOTAL---(Total for actual)-----------(total for prev)-------(Total for prev/Total for actual)

     

    hope this helps.

Legend

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