Skip to Content
avatar image
Former Member

Bex report for week3 and previous week for all weekdays

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..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 25, 2017 at 11:49 AM

    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)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.