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