6 Replies Latest reply: Jun 30, 2011 9:11 AM by Nagaian Krishnamoorthy RSS

    How to use peek function to compare the cells abover or below for different groups

      I need to prepare report where i have for RMA more statuses.

      For RMA 'A' I have statuses cancel. alloc and 2times nonalloc for RMA 'B' nonalloc & ship.

       

      RMAStatus
      A5 cancel
      A4 alloc
      A6 nonalloc
      A6 nonalloc
      B6 nonalloc
      B3 ship


      I would like to see just one status per one RMA, so for example "

      • for RMA 'A' one of the statuses is 4 alloc --> i would like QV to set up the status for whole RMA 'A' as 4 alloc
      • for RMA 'B' one of the statuses is 3 ship --> i would like QV to set up the status for RMA 'B' as 3 ship

      as below:

       

      RMAStatusNewStatus
      A5 cancel4 alloc
      A4 alloc4 alloc
      A6 nonalloc4 alloc
      A6 nonalloc4 alloc
      B6 nonalloc3 ship
      B3 ship3 ship

       

      I was trying to sort RMA & statuses and then use PEEK function but it doesent work. Any ideas how to solve it?