11 Replies Latest reply on Jun 20, 2017 12:23 PM by aisha.elzein.0

    YTD and Prior YTD

    David Shishir

      Hi All,

       

      Can you please help me out in calculating YTD and prior YTD calculations in the attached workbook.

       

      Fiscal year FY2017 ranges from Apr-2016 to Mar-2017

      Fiscal year FY2018 ranges from Apr-2017 to Mar-2018

       

      If i select the date parameter as Feb-2018, YTD should be addition of actuals from Apr-2017 to Feb-2018 and Prior YTD should be addition of actuals from Apr-2016 to Feb-2017

       

      Kindly let me out with the calculation.

       

      Many thanks in advance

      David