4 Replies Latest reply on Jul 16, 2018 1:48 AM by Shiva Pillai

    Max / Window Max help!!?

    Shiva Pillai

      Hello everyone,

       

      I have a question relating to MAX (or perhaps WINDOW_MAX) functionality. I have a data set that has names, target dates and forcasted closure date (FCD). FCD is not available for all the values in my data set. Where the FCD is not available, I would like this to be the maximum of target date plus 30 days.

      Can someone please advise what formula can I use to get the Date if FCD is blank (in the table below)?

       

      NameTarget DateFCD

      Date if FCD is blank

      max of Target Date + 30 days

      AAA31/12/201630/10/2022
      AAB01/05/201831/06/2018-
      AAC31/03/202030/10/2022
      AAD31/09/202230/10/2022
      AAE01/08/201830/10/2022
      AAF31/12/201731/09/2018-
      AAG01/03/201930/10/2022
      AAH31/03/202230/10/2022
      AAI31/03/201531/03/2015-
      AAJ01/03/201830/10/2022