Formula for On Time Delivery %

Avatar
Archana Maltesh

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?

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
3 commentaires
Avatar
Pietro Poli

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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
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]))

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Pietro Poli

perfect! Thanks for sharing Archana Maltesh

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Formula for On Time Delivery %
[this list is visible for admins and agents only]

Haut de la page
Didn’t find what you were looking for? Write new post