Formula for On Time Delivery %

I am trying to create a formula for On Time Delivery % which would be Percentage of projects delivered on-time compared to total projects delivered in the quarter

We define On Time as difference between Actual launch date and planned launch date being with +/- 5 days

How would I create this formula for the %? I can create the formula for difference in days using DDIFF.

How do I find the # of projects that fit the criteria and then calculate that as a % of the total projects?

Find more posts tagged with

Comments

Pietro Poli

Hi @Archana Maltesh,
can you share your formulas?
I would try to help you

Archana Maltesh

Thank you for the offer @Pietro Poli - I got help from the Wrike Analyze expert we were working with. This is the formula we came up with which seems to be working well at this time:

(SUM([Project ID],if(max(DDIFF([Days in Planned Launch Date at PDR],[Days in Est/Actual Launch Date]))>=0,0,1)))/(COUNT([Project ID])-(count([Project ID]),[N/A]))

Pietro Poli

perfect! Thanks for sharing @Archana Maltesh

Cynthia Sperry

Thank you!