BEx report: How to calculate cell values using cell definition

[former_member428214]

Hi All,

We have a a requirement, where i have to use

• Sunday Week2 closing = 0calweek restricted by current cal week (sap variable) offset -1 &
• Monday Week3 sales = 0calday = monday & 0calweek restricted by current cal week (sap variable) to get the Closing Values for Monday week3 and the formula was given by the functional team as ( Sunday Week2 closing - Monday Week3 sales = Monday Closing )
• When i implement the above formula it is not giving the correct values...

Example:

21.05.2017 ( Sunday) closing value is 620

29.05.2017 ( Monday ) Current Week Sales is 400

The expected result is 220, but it is giving me as -400.

some how it is not taking the value from previous row into the current row and use it for calculation, i tried to achieve this using CKF/Formula but no success.

Please provide your inputs.