5 Replies Latest reply: Aug 14, 2017 3:31 PM by Michael Rainey RSS

    Variable and Set Analysis

    Michael Rainey

      I am trying to do a sum of months less than the current month/year:

       

      Sum({<[CalendarDate.autoCalendar.YearMonth] =- { '$( =$(vCurrMonthYear) )' }>}Total)

      vCurrMonthYear = MonthName(addmonths(today(),-1))

       

      This does not work.  Any other ideas?