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

    YTD-1 Excluding Current Month Y-1

    Benjamin Rubattel



      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?