2 Replies Latest reply on Oct 12, 2018 5:28 PM by Shinichiro Murakami

    YTD-1 Excluding Current Month Y-1

    Benjamin Rubattel

      Hello,

       

      I want to do a comparison YTD, Excluding Current Month, to YTD-1 Excluding current month Y-1 .

       

      For instance, I am excluding October data 2018 with the following formula:

       

      datetrunc('month', [Order Header Creation Date]) = datetrunc('month', Today())

       

      I am looking to Exlude the Same month of last year, I haven't find a solution.

       

      Any help?

       

      thanks

      Benjamin