2 Replies Latest reply: Mar 8, 2017 3:30 AM by Carl Blunck RSS

    Set analysis help

    Carl Blunck

      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!!