5 Replies Latest reply: May 6, 2016 2:37 AM by Settu Periyasamy RSS

    Change in Values

    reddy r

      TABLE1:

         

      IdNameStatusRiskDate
      100ABCOpenLow10/1/2014
      100ABCClosedMedium3/2/2014
      200DEFOpenLow1/1/2015
      200DEFOpenMedium1/2/2015
      200DEFClosedHigh1/3/2015
      300XXXOpenHigh5/6/2015
      300XXXOpenLow7/7/2015
      300XXXClosedHigh8/9/2015
      400YYYOpenLow1/2/2015
      400YYYClosedMedium2/2/2015

       

      I would like to see where the Risk  for a Id changes from when we first receive the Id's risk  in the above table to when their Status changes to Closed    

      How many Ids changes risks/ For a closed id in the above table - has the status changes since Open? A flag needs to be added to know rish changes or not(y/n)

      Help me on the above?