3 Replies Latest reply: Dec 1, 2017 7:01 AM by Adam Tate RSS

    Set Analysis Month Query

    Adam Tate

      Hi,

       

      I am trying to get a sum of the amount of lines sold for this current month using set analysis  with the following:

       

      SUM({$<Month([Order Date]) = {month(today())}>} [Line Amount])

       

      I am getting errors, any ideas?

       

      Thanks in advance