14 Replies Latest reply: Sep 17, 2018 6:26 AM by Hanan Ali RSS

    Less than equal to Selected year and month

    Hanan Ali

      i need to show data until selected year and Month


      have Joining date till the selected year moth need to know number of employees


      tried build two variables

      1.vYear ==passing selected year

      2. vMonth =passing selected Month


      3. concatenation both variables vyearmonth =vYear &vMonth


      have column year(joinng date)&month(joining date)  created this column in database









      used below expression but not working

      =Count(distinct{<yearmonth=  {"<=$(vyearmonth )"}>} empno)

      need urgent


      it s beheaving strange