Skip to Content
0

Bex report for week3 and previous week for all weekdays

Apr 25, 2017 at 09:00 AM

135

avatar image

Hi All,

I have a requirement to create a report as below:

Week3 - Based on ocalweek & based on aggregation of 0CALDAY. See CALL FUNCTION 'DATE_GET_WEEK'

Sunday Week2 closing = Current 0CALWEEK - 1 week

Monday Week3 sales = Daily keyfure value of the current weekon Monday

Tuesday Week3 sales = Daily keyfure value of the current weekon Tuesday

Wednesday Week3 sales = Daily keyfure value of the current weekon Wednesday

Thursday Week3 sales = Daily keyfure value of the current weekon Thursday

Friday Week3 sales = Daily keyfure value of the current weekon Friday

Saturday Week3 sales = Daily keyfure value of the current weekon Saturday

Sunday Week3 sales = Daily keyfure value of the current weekon Sunday

I got the Weekday values captured in a Zfield and now i want to use it to get the above values..

Please provide your inputs..

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

1 Answer

Best Answer
Koen Hesters Apr 25, 2017 at 11:49 AM
0

Hi,

in bex

general filters set 0calweek from current week to current week (offset -1)

create restricted key figures

  • Week3 - 0calweek restricted by current cal week (sap variable)
  • 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)
  • Tuesday Week3 sales = 0calday = tuesday& 0calweek restricted by current cal week (sap variable)
  • Wednesday Week3 sales =0calday = wednesday & 0calweek restricted by current cal week (sap variable)
  • Thursday Week3 sales = 0calday = thursday & 0calweek restricted by current cal week (sap variable)
  • Friday Week3 sales = 0calday = friday & 0calweek restricted by current cal week (sap variable)
  • Saturday Week3 sales = 0calday = staruday & 0calweek restricted by current cal week (sap variable)
  • Sunday Week3 sales = 0calday = sunday & 0calweek restricted by current cal week (sap variable)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Koen,

Now there is 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.

0