0 Replies Latest reply: Mar 23, 2017 10:54 AM by David Desouza RSS

    Count within date range

    David Desouza

      I have two tables - one contains a list of customers, countries, order dates, and delivery dates.  The other contains a list of all possible countries and delivery deadlines.  I want to determine the number of orders that were filled within the deadline by country.  Orders filled after the deadline should be ignored.

       

      The following counts the orders filled, but does not ignore the orders filled after the deadline.

       

      Count({<Delivered={'<=$(=lookup('Deadline','Active Countries',[Order Country]))'}>}[Delivered])

       

      What am I missing to properly exclude the delivery dates that fall after the deadline?