2 Replies Latest reply: Dec 22, 2016 5:59 AM by Erik Hoeben RSS

    Count based on actual delivery date compared to planned delivery date

    Erik Hoeben

      Hi,

       

      How do i make a count (that complies to selections) on 2 date fields. I have a DATERECEIVED field which is the actual deliverydate and a DELIVERYDATE which is the planned deliverydate. My goal is to get a % of the orders that are delivered on time.

       

      My plan was to make a

       

      =Count(statement that selects where DATERECEIVED < DELIVERYDATE) / Count (all deliveries)

       

      i cant figure out how to formulate the statement.