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