Skip to Content
0

Getting Prev Day value in Today's date in BEx

May 30, 2017 at 05:44 PM

72

avatar image

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.

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

1 Answer

Mario Tibollo Jun 01, 2017 at 02:09 PM
0

why don't you just create the CKF:

CKF = Valuated stock qty + qtylssValStock - RecQtyValStock

this gives the stock value of the previous day.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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)
0