8 Replies Latest reply: Oct 21, 2011 5:31 AM by Jerome Hanff RSS


    Jerome Hanff



      i want to calculate YTD and YTD -1 .

      i have this right now



      sum({$<YEAR = {$(=max(YEAR))}, MONTH = {"<=$(=max({<YEAR={$(=max(YEAR))}>} MONTH))"}>} VALUESALES)


      sum({$<YEAR = {$(=max(YEAR - 1))}, MONTH = {"<=$(=max({<YEAR={$(=max(YEAR))}>} MONTH))"}>} VALUESALES)


      But what i want is to go do the exact day in the month, not just the month

      ex: from (YTD-1) 01.01.2009 to 19.10.2009 and 01.01.2010 to 19.10.2010



      any idea how to complete this function to do so?


      Thanx in advance for your help