6 Replies Latest reply: May 5, 2017 3:08 AM by Ravi Kishore RSS

    Prior Year YTD, Prior Year MTD,Prior Year QTD in Absence of Date Field

    Ravi Kishore

      Hi Friends,

       

      Please help me to create Prior Year MTD,QTD,YTD.

       

      I have attached the Data Sample . I dont have date Field in my Data and i cant use Date field as my data has Granularity for Month wise only. so i cant use today function .

       

      I was able to calculate MTD,QTD, YTD for Current Year.

        

      v$MTD Sum({<TYMONTH={'$(vMaxMonth)'}>}TY_NETDOLLARS)/1000000
      v$QTDSum({<Year={'$(vMaxYear)'},TYQUARTER={'$(vMaxQuarter)'}>}TY_NETDOLLARS)/1000000
      v$YTDSum({<Year={$(vMaxYear)}>}TY_NETDOLLARS)/1000000

       

      But stuck in Creating MTD, QTD YTD for Previous Year

       

      It would be great help if some one can through some pointers.