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

    exclude current month

    Joanna Seldon



      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