10 Replies Latest reply on Jan 7, 2016 8:12 AM by Gopi Chand

    Previous YTD data turn to PY Full Year

    Musytaqual Hasan

      Hi all,


      I want to create new field with Previous Year YTD data.

      I have try formula as below:


      If [Month]<=[Period] and DATEDIFF('year',[Month],[Period]) = 1 then [Actual Revenue] END


      but the result is data return with full year (sum of 12 months) not YTD.


      Please check my sample data below:


      Thanks in advance,