2 Replies Latest reply on Nov 6, 2013 10:13 AM by Aaron Clancy

    Need Help with IF statement

    Elizabeth Coleman

      Hello,

       

      Here's the scenario that I need help with.  I am working with Supply Chain data that I trying to determine using a calculation what percentage of the orders have an install planned date and has shipped completely from the factory.  My first thought was to use a IF statement but not sure how to approach it.  I've attached a sample of my data and I attached my file. If the date is empty or "01/01/01" = unplanned; Shipment Complete = C (everything shippped), B = partially shipped, A or Blank = Nothing shipped.

      Header 1Header 2Header 3Header 4
      order #Shipment CompleteEQUIP $Install Planned Date
      2C5500
      3C656001/01/01
      41222004/5/2013
      5A

      4656

      05/20/2013
      6C785601/01/01
      7A445606/24/2013
      8A895601/01/01
      9C2314
      10B152301/01/01