Getting Prev Day value in Today's date in BEx

[former_member428214]

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.

[former_member186445]

why don't you just create the CKF:

CKF = Valuated stock qty + qtylssValStock - RecQtyValStock

this gives the stock value of the previous day.

[former_member428214]

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 .