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



      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.