4 Replies Latest reply: Mar 16, 2018 8:30 AM by Jahanzeb Hashmi RSS

    QS- Sum where date less than

    Miguel Cunha

      hey guys,


      basically, I need to sum my sales from 2018 but only January and February. I want to exclude the current month.


      I'm trying to do the following:


      =sum({$<Date_Year={'$(=year(vMaxDateSalles))'}, Date_Month={"<$(=month(vMaxDateSalles))"}>} s_Salles)


      vMaxDateSalles is a variable I created with the max Date.


      Am I doing something wrong? I tried with ' instead of ", and also tried <= instead of < , just for curiosity, but 0 success.


      Can you help me?


      Thanks in advance,
      Miguel Cunha