3 Replies Latest reply on Apr 15, 2016 4:02 AM by Devendra Sahu

    Need Calculations of MTD,Full Month,YTD & Full Year for particular measure

    Koushik Neelakantha

      Hello All,

       

      I need to calculate MTD,Full Month,YTD & Full Year for particular measure.

       

      For MTD and YTD  Please find the below calculation which i Implemented.

       

      MTD:

       

      if YEAR([FISCAL_DATE]) = YEAR(TODAY())

      and MONTH([FISCAL_DATE]) = MONTH(TODAY())

      then ([LOCAL_SALES])

      END

       

      YTD:

      if year([FISCAL_DATE])=year(TODAY()) then [LOCAL_SALES]

      END

       

      Similarly i need to calculate the same for Full Month and Full Year.

       

      Regards,

      Koushik.