5 Replies Latest reply: Feb 9, 2018 10:03 AM by Amarinei Neculai RSS

    Eliminate Current Month

    Selva A

      Hi Team,

       

      I have req like exclude the current month while calculate the average ref lines

       

      Eg:

       

      If i selected a year 2018 (Jul 2017 to Feb 18 ) will come .

       

      Total counts = 112 (Include feb 18). But I want to  exclude feb 18 while adding ref lines

       

      At the same time it won't affect rest of the previous years

       

      My expression  :Count({$<[Group] = {'dfgdg'}>} DISTINCT xyz ))  it will return 112

       

      Here how can i exclude feb ?

       

      1.PNG

       

       

      REF line expression is :  

       

      Count({$<[Group] = {'dfgdg'}>} DISTINCT xyz ))  / Count ([Year Month])

       

       

      if i remove the feb in the calculation avg line should b 15.9

       

      Please help on this

       

      Thanks