Peek and create flag

[markgraham123]

Hello,

Here is my original data set in the application.

REQ field is just repeating.

Any help ism highly appreciated.

ITEM	Location	Available	AvailableDate	REQ	Can fill
1	Dallas	204	10/24/2017	104	104
1	Dallas	300	11/5/2017	104
1	Dallas	60	11/15/2017	104
1	Dallas	204	12/1/2017	104
1	Dallas	204	12/2/2017	104
2	Chicago	35	10/21/2017	2	2
2	Chicago	40	12/1/2017	2
2	Chicago	44	12/1/2017	2
2	NY	38	12/5/2017	3
2	NY	43	12/5/2017	3
3	Chicago	300	10/21/2017	250	250
3	Chicago	0	12/1/2017	2
3	Chicago	0	12/1/2017	2
3	NY	3	12/5/2017	400	3
3	NY	10	12/5/2017	3

[its_anandrjs]

Hope you are looking this

Add new field as

if(REQ=Previous(REQ),' ' ,REQ) as NEW

[markgraham123]

Anand,

I'm looking to calculate (Available - REQ) to see how many i can fill in the 'Can fill' column

[markgraham123]

stalwar1‌

[Anil_Babu_Samineni]

Can you explain behind the logic? Atleast consider as 1 row to show output

[its_anandrjs]

Not clear please elaborate more of provide the expected output here to and understand the output.

[markgraham123]

Item 1 has 104 units of requirement.

I'm getting 2014 units on 10/24.

So, i can fill those 104 units.

Now. i go to Item 3 at NY.

It needs 400 but i'm getting only 3 units on 12/25.

So, i can only fill 3

[markgraham123]

Item 1 has 104 units of requirement.

I'm getting 2014 units on 10/24.

So, i can fill those 104 units.

Now. i go to Item 3 at NY.

It needs 400 but i'm getting only 3 units on 12/25.

So, i can only fill 3

[Anil_Babu_Samineni]

Again not clear, What is the value 2014 and 10/24?

[sujith1011]

Hey Mark,

Could you please provide a little more detail please

which one is a calculated field here, are you trying to calculate REQ, here ?

also

Item 1 has 104 units of requirement.

I'm getting 2014 units on 10/24.  where is 2014 coming from its not there in your example

if you could provide the value of REQ that should actually appear then it will be helpful