Count based on actual delivery date compared to planned delivery date
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)