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,

      Musytaqul