1 Reply Latest reply on Jun 17, 2019 1:43 PM by ALEX GRAHAM

    Month to Date, Year to Date etc calculations using Custom calendar

    ALEX GRAHAM

      Hi Everyone,

      I am using Custom calendar as our Fiscal Year. Our Fiscal Year is July to June but dates may not be as per calendar date means month may start June 29 but still be considered in the month of July, similarly ending is also not as per calendar months.

      I have a parameter Year  to Date, Month To date, Prior Month and Quarter to Date and want to show data as per Fiscal month, quarter and Year.

      Attached is the sample work book with expected results shown in text box.

       

      Your help will be highly appreciated.

       

      Thanks!

       

      Alex