5 Replies Latest reply: Jun 7, 2016 2:23 AM by muhammad fahad RSS

    finding max stage and delay in process

    muhammad fahad

      hi grus....!!!!

       

      I have the following table

      Demand_noProcessOrderProcess_dateProcess_id
      IT-922Demand001-01-2016sdfdsafs
      IT-922IT105-01-2016sdfsafsd
      IT-922Tender208-01-2016sdfsadfsdf
      IT-922Quotation312-01-2016sdfsdfsxcv
      IT-922Po405-02-2016sdfrjgh
      IT-922Payment510-02-2016dtyiyum
      HR-899Demand014-01-2016ghiyhjgh
      HR-899IT118-01-2016yuiyukj
      HR-899Tender220-01-2016hnmvbxc
      HR-899Po425-01-2016gfhgftyty
      DD-2342Demand013-03-2016sdfer
      DD-2342IT115-03-2016eertet
      DD-2342Tender220-03-2016weregdfgf

      now i have shown 3 different demand each of them has different max process..

      IT-922 is in payment process

      HR-899 is in Po process

      DD-2342 is in Tender process

       

      Requirement 1:now i want to show these above maximum process in a table

       

      Demand_noCurrent_Stage
      IT-922 Payment
      HR-899Po
      DD-2342Tender

      Requirement 2: I also want a separate table showing delay from each process to another

       

      Demand_noProcess Delay in days
      IT-922Demand0ff
      IT-922IT4
      IT-922Tender3
      IT-922Quotation4
      IT-922Po23
      IT-922Payment5
      HR-899Demand0
      HR-899IT4
      HR-899Tender2
      HR-899Po5
      DD-2342Demand0
      DD-2342IT2
      DD-2342Tender5

      plzzz help