Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Try
Sum({$<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=,[Payment Type Category]={'Overtime'}>} Hours)
Try
Sum({$<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=,[Payment Type Category]={'Overtime'}>} Hours)
Mate, cheers the quick response. Seems to work. Legend.