7 Replies Latest reply: Nov 24, 2017 1:37 AM by Shraddha Gajare RSS

    Set analysis

    poojashri bangera

      MONTH_KEY.PNG

      I have month_key and date field.

      now i want to select yearstart i.e. April  month_key dynamically.

      if it is 2018 then month_key should be 201804 .


      (sum({<Month_key={"201704"} ,emp_cat_code={'R'},officer_cd = {'*'}-{'CD'}>} QTR_OPEN_CNT)+

         sum({<Month_key={"201710"} , emp_cat_code={'R'},officer_cd = {'*'}-{'CD''}>} QTR_CLOSE_CNT))/2)

       

       

      Please help