Variable and Set Analysis

[mrainey18]

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?

[Clever_Anjos]

Which format are your variable output and your calendar field? Are they the same?

[mrainey18]

They are the same. 

[Clever_Anjos]

Could you double check?

[mrainey18]

Yes.  I did check.  They match both are formatted "MMM YYYY"

Should I use a different format?  I tried num() but couldnt get the less than to work.  Do you know how to do that?

Something like this:

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

Not sure where to put the <..

Sum({<CalendarDate =- { '$( =$(vCurrMonthYear) )' }>}Total)

CalendarDate is already the min number of each month.

[mrainey18 · Accepted solution]

Got it:

Sum({$<CalendarDate = { "$(='<' & $(vCurrMonthYear))" }>}Total)

vCurrMonthYear = num(MonthName(addmonths(today(),0)))