on 05-30-2017 6:44 PM
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.
why don't you just create the CKF:
CKF = Valuated stock qty + qtylssValStock - RecQtyValStock
this gives the stock value of the previous day.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 .
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.