Pages

Monday, February 18, 2013

Get the previous row value in OBIEE 11g

Way of getting a value of the previous row: Use MSUM (MovingSum)

Actuals: "MCSR"."Actuals PJTD"

Previous Actuals:  MSUM("MCSR"."Actuals PJTD",2) - "MCSR"."Actuals PJTD"

Try this.....

1 comment: