Project Health Calculation

leezee

Please can you assist.

I am currently using the SS Standard template Schedule Health Formula :

Project Heath Formula

=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green"))

My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas below which use duration)

How can I adapt the formula to revert to the parent health where duration is Zero ?

Schedule Delta Formula :

=IFERROR([Schedule Delta (Working Days)]@row / Duration@row, "")

Schedule Delta (Working Days) :

=IFERROR(IF([End Date]@row = [Baseline End Date]@row, 0, IF([End Date]@row > [Baseline End Date]@row, NETWORKDAYS([Baseline End Date]@row, [End Date]@row) - 1, IF([End Date]@row < [Baseline End Date]@row, NETWORKDAYS([Baseline End Date]@row, [End Date]@row) + 1, ""))), "")

Many Thanks

Lee

Paul Newcome

@leezee I responded on your other thread.