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

    WIP Count

    Ashley Inman

      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 DateClosed DateReporting Month
      17/1/2018 7/1/2018
      17/1/2018 8/1/2018
      17/1/20189/15/20189/1/2018
      28/15/2018 8/1/2018
      28/15/2018 9/1/2018
      28/15/2018 10/1/2018
      28/15/201811/6/201811/1/2018

       

        This is the WIP Count I would like to see

      MONTHWIP COUNT
      7/1/20181
      8/1/20182
      9/1/2018                    1
      10/1/20181
      11/1/20180