10 Replies Latest reply: Oct 14, 2013 1:56 PM by Manuel Altamirano RSS

    sum only records of today's month

      Hi !

       

      i am trying to create an expression that will sum a field but only when the record's date is today's month.

       

      this is what i wrote and it's incorrect:

       

      =sum({<MonthName(date) = {"monthName(Today())"} >} clicks)

       

      for example:

      dateclicks
      10/1/201310
      10/2/20133
      10/3/20137
      10/4/20138
      10/5/20133
      9/1/20132
      9/2/20138
      9/3/20133
      9/4/20139
      9/5/2013

      2

       

      i want the expression to sum only the records from October.