Set analysis help

[blunckc1]

Hi everyone,

I'm still getting my head around set analysis and I found the following set analysis expression which works great.

Sum({<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=>} Hours)

I need to however add another modifier to this and I have no clue how or where!  The modifier that needs to be added is bolded in this much more straight forward set analysis expression.

Sum({$<[Payment Type Category]={'Overtime'}>}Hours).

Can you someone please point me in the right direction?

Thank you!!

[shraddha_g · Accepted solution]

Try

Sum({$<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=,[Payment Type Category]={'Overtime'}>} Hours)

[blunckc1]

Mate, cheers the quick response.  Seems to work.  Legend.