Skip to Content
0

BEx report: how to get previous row value into a cell using Cell definition

May 29, 2017 at 01:37 PM

63

avatar image

Hi All,

I have a requirement where i have to use previous week value today for calculation.

Requirement:

0calday | 0calweek | matnr | last weekvalue | today value closing | ( Lastweek-Today value)

27.03.2016 |14 | 1102 | 602 | nill | nill

29.03.2016 |15 | 1102 | | 400 | (602-400) = 202

How can i achieve 202 value, i tried using some calsulations but it not getting the previous row value into the current row instead it is displaying as -400 instead of 202 as closing value.

I think this can be achieved using cell definition but not sure how to implement the logic.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers