1 Reply Latest reply on Sep 30, 2016 5:20 PM by swaroop.gantela

    Identify Different Values for a grouping with multiple rows

    Chuck Blechle

      I have a Sales Order Nbr with multiple Order Line Nbr shipped per order.  I am trying to identify order numbers that all lines have shipped on the same day vs orders that have shipped on multiple days (Highlighted in Red).  Looking for a simple Yes No answer.

       

         

      SALES ORDER NBRORDER LINE NBRACTUAL SHIP DATE
      01V132A11/20/2016
      21/20/2016
      01V140A11/1/2015
      22/24/2016
      32/24/2016
      42/24/2016
      52/24/2016
      62/24/2016
      72/24/2016
      82/24/2016
      92/24/2016
      01V143A14/11/2016
      24/11/2016
      34/11/2016
      41/1/2015
      54/11/2016
      64/11/2016
      74/11/2016
      84/11/2016
      94/11/2016