1 2 Previous Next 15 Replies Latest reply on Oct 17, 2018 2:52 PM by Shinichiro Murakami

    YTD Calc using DateDiff Function

    Ritu Chandiramani

      I am in the process of calculating the YTD values using the Datediff function (see below screenshot). I am running into two issues:

      • How to sum up the current month and previous month values?
      • How to restart the calculation for every year.

       

      Note - I need to use these YTD values in LOD calculations, so Table calculations, Window Sum etc. will not work. I have already tried them.

       

        1 2 Previous Next