2 Replies Latest reply: Jan 30, 2017 9:01 AM by Mohamed Ilyas Pitchai Mohamed RSS

    Applying Year Filter

    Mohamed Ilyas Pitchai Mohamed



      I am trying to apply the year filter to the column in the left but unfortunately i'm not getting any results. (Its zero)


      Below is the set analysis string im applying:

      sum({1<DATE(MNDATE,'YYYY')={'$(vRepYrCrnt)'}>} ENDTOT)


      MNDATE has starting dates of each month, like (20160101.... 20161201) and my variable vRepYrCrnt=2016


      Your help will be much appreciated.