6 Replies Latest reply: Jul 2, 2018 10:20 AM by Pascal Dijkshoorn RSS

    Current year until last month vs. last year until last month

    Pascal Dijkshoorn

      Hi guys,

       

      I want to make a comparison for this year until last month vs. last year until last month. So for today that would mean i would compare January - June 2017 with January - June 2018.

       

      I am using the following formula for current year:

      Sum ({$<[L_BEGIN_DATE.autoCalendar.MonthsAgo]={">0"},[L_BEGIN_DATE.autoCalendar.YearsAgo]={"0"}>}Revenue)

       

      But I can't figure out how to calculate last year. Who knows the correct formula?

       

      Thanks in advance