7 Replies Latest reply on Nov 9, 2018 2:34 PM by Deepak Rai

# WIP Count

I'm looking to create a formula that will help me determine how many units there are in WIP at the end of each month.

I have a received date and a closed date but not sure how to write the calculation for WIP.

If there is no closed date then shipment is considered in WIP. Hoping to use the received date and if closed date is not within the reporting month then WIP.

DATA

 Shipment # Received Date Closed Date Reporting Month 1 7/1/2018 7/1/2018 1 7/1/2018 8/1/2018 1 7/1/2018 9/15/2018 9/1/2018 2 8/15/2018 8/1/2018 2 8/15/2018 9/1/2018 2 8/15/2018 10/1/2018 2 8/15/2018 11/6/2018 11/1/2018

This is the WIP Count I would like to see

 MONTH WIP COUNT 7/1/2018 1 8/1/2018 2 9/1/2018 1 10/1/2018 1 11/1/2018 0
• ###### 1. Re: WIP Count

Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

• ###### 2. Re: WIP Count

This is great! One follow up question, if there is a closed date how would I count the units in WIP within that given month? Essentially I want to snap the number of units for every month.

• ###### 3. Re: WIP Count

Sorry, Can you give an Example from your data?

and also Remove ZN from my last Formula. That was not necessary.

• ###### 4. Re: WIP Count

This is what I have data wise on the attached. I guess the thing that might be throwing me off is the reporting month. Because I over write the reporting month, I can't use that as my columns header.

Due to some of my data I could only show the dates.

{FIXED [Customer], DATETRUNC('month',[Receive Date])

: count (if isnull([Repair Order Closed Date]) then [Repair Quantity] end)}

• ###### 5. Re: WIP Count

I am confused because you have entire data in one column not separate headers, but coming to your second question, if you havea  closed date, then that is not a WIP thing. It is already done. Isn't it?

• ###### 6. Re: WIP Count

That's true, but I want to see how many units I had at the end of each month in WIP if that makes sense whether or not had a closed date? I'm sorry I probably didn't explain that question well enough.

• ###### 7. Re: WIP Count

So in that Case, Your Calculation Will Be:

Thanks

Deepak