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

    Applying Year Filter

    Mohamed Ilyas Pitchai Mohamed

      Hi

       

      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.

       

      Regards

      Ilyas