7 Replies Latest reply on May 5, 2014 11:12 AM by Srini VEERAVALLI

    Complex calculation

    2624005

      Dear sir,

       

      I've problem can't solve, please advise.

       

      Example

      I have 2 column , A and B

      And need to calculate C is come from A - B

      But I need value from normal (Sum) aggregate for A but I need value from "Last" aggregate for B

      In report I can select Aggregate option for A and B

      value of A and B show correct (from requirement)

      But  when I calculate C , it use sum A - sum B

       

      So my question is how I calculate C by sum(A) - Last(B)

      And my constrain is B is come from lookup function in OBIEE so I can't put last function in OBIEE Admin formula.

       

      Please help.

       

      Thank you