13 Replies Latest reply: Oct 13, 2015 9:11 AM by Joanna Seldon RSS

    exclude current month

    Joanna Seldon

      Hiya

       

      have a kpi

       

      I am trying to write something like this

       

      sum({$< Order_Date -={$(Month(getdate()))}  >}Customer_ID)

       

      I wish to exclude this months 'October 2015'  (When this post was written)  orders for customers

       

      where am I going wrong

       

      please help