Skip to Content
avatar image
Former Member

Getting Prev Day value in Today's date in BEx

Hi All

I need to get the previous day value in todays date as shown below. I tried to achieve this using CKF with 0calday ( 0DAT - 1) but it is giving me value only for that particular day but i want to display that day value in today's date.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 01, 2017 at 02:09 PM

    why don't you just create the CKF:

    CKF = Valuated stock qty + qtylssValStock - RecQtyValStock

    this gives the stock value of the previous day.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mario,

      Yes we can get the Previous day value using CKF, but i want to use that previous day value today for calculation. if you see below screenshot, i am getting the sunday week2 closing value and monday current week sales.

      Now i want to calculate monday closing using formula ( sunday week2 closing - monday current week sales ) but the desired result is not coming as the values are in different rows.

      720 - BLANK = 720...so on

      BLANK - 500 = -500..... but my desired result is 720-500 = 220 .

      g078.jpg (34.9 kB)