Skip to Content
0

BEx report: How to calculate cell values using cell definition

May 30, 2017 at 08:23 AM

58

avatar image

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.

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

0 Answers