5 Replies Latest reply on Dec 9, 2018 12:57 AM by Yuriy Fal

    Open and Close Dates - assuming renewals

    cynthia.loke

      Good evening all, and I thank you in advance for any assistance you can provide on a problem that has me stumped.

       

      I am working on contract data with open and close dates per customer.  As you can see in my dataset below, clients often elect to renew their contracts, and I would like to capture a 100% renewal rate scenario.

       

      So for the dataset below, I would like to take the contracts with the latest end date (noted in red text below), and extend that out into the future- say another 10 years (this is arbitrary).

       

      I've attempted to play around with previous_value and fixed LOD calculations, but can not seem to get it to work.  Any suggestions?  Thanks again!

       

         

      Customer IDContractsStart DateEnd Date
      63229350.312/15/20176/30/2019
      63229350.37/1/20196/30/2020
      05510425/1/20185/31/2019
      05510426/1/20195/31/2020
      2088896/1/20183/31/2019
      2088894/1/20193/31/2020
      2089746/1/20185/31/2019
      2089746/1/20195/31/2020
      3370647/1/20185/31/2019
      3370646/1/20195/31/2020
      551362.78/1/20186/30/2019
      551362.77/1/20196/30/2020
      7023629/1/20185/31/2019
      7023626/1/20195/31/2020