2 Replies Latest reply: May 16, 2017 7:01 AM by sanjay gupta RSS

    MTD and YTD

    laxman V

      can anyone let me know where can i find the complete info on how to work with MTD and YTD.

      and how to calculate the values of MTD and YTD.

        • Re: MTD and YTD
          sanjay gupta

          MTD :

           

          ((Sum({<FYear={"=max(FYear)"}, MONTH1=, Quarter=,DATE_SLIPDATE1=, NUM_DATE={">=$(=Num(MonthStart(Max(NUM_DATE))))<=$(=Max(NUM_DATE))"}>} ACCOUNTED_CR)- Sum({<FYear={"=max(FYear)"}, MONTH1=, Quarter=,DATE_SLIPDATE1=, NUM_DATE={">=$(=Num(MonthStart(Max(NUM_DATE))))<=$(=Max(NUM_DATE))"}>} ACCOUNTED_DR)))/1000000

           

          YTD:

           

          sum({<DATE_SLIPDATE1=,YEAR=, MONTH1=, NUM_DATE={">=$(=Num(MonthStart(Max(NUM_DATE),-11)))<=$(=Max(NUM_DATE))"}>}ACCTD_AMOUNT)/1000000

           

          * this is for the financial year starts with Apr and ends at Mar