4 Replies Latest reply: Nov 10, 2015 11:34 AM by Sunny Talwar RSS

    count differently if different date

    Joanna Seldon

      Hiya

       

      I wish to on a chart, on after a certain date, count different conditions

       

      I have the following expression

       

      e.g

       

      if(OrderDate < '01/01/2015', count({$<  DeliveryType = {"1"}CustomerID)) or

      if(OrderDate > '01/01/2015', count({$<  DeliveryType = {"2"}, CustomerID))

       

       

      I am having no joy

       

      please advise / help