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

    Complex calculation

    Chiaranon Thimkul

      Dear sir,


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



      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