6 Replies Latest reply on Jan 2, 2019 9:30 AM by olanrewaju.oyeyinka

    Previous Year QTD calculation

    olanrewaju.oyeyinka

      Hi,

      I am trying to compare my current year and previous year QTD, but i was only able to get my current year leaving my previous year null.

       

      I used these below and return the current year:

       

      IF [date]<= TODAY() AND

      DATEPART('quarter', date) = DATEPART('quarter',TODAY()) AND

      YEAR([date) = YEAR(TODAY()) THEN

      [Volume in measures]

      END

       

      any input please

       

      thanks

      larry