12 Replies Latest reply: Jun 5, 2017 7:03 AM by Vineeth Pujari RSS

    Closed on this month

    Anjali Ahlawat

      Hi Experts,

       

      I am using below formula to showcase numbers that are closed on this month:

       

      CommonDateNum={">=$(=Num(MonthStart(Max(CommonDateNum)))<=$(=Max(CommonDateNum))"

       

      But I can see that there are still some tickets that are not coming after applying this condition,i thought that "=" is not working in the below condition,so I added -1 in the expression to consider all values.

       

      CommonDateNum={">=$(=Num(MonthStart(Max(CommonDateNum))-1))<=$(=Max(CommonDateNum)-1)"

       

       

      Please let me know if this condition is fine or do I need to change something....

       

      Thanks in advance.