First off there is an error in your formula so that it counts weekends into the number of days. Because of this a task that is only really only 19 working days late is shown by your formula to be 27 days late. I have made some adjustments below:
IIf([% Complete]=100,"Task completed",IIf(ProjDateConv([Baseline Finish])="NA","Task not agreed",IIf((ProjDateDiff([Baseline Finish],[Finish],"Standard")/60/8)<=20 And (ProjDateDiff([Baseline Finish],[Finish],"Standard")/60/8)>7,"Task >1 week late",IIf((ProjDateDiff([Baseline Finish],[Finish],"Standard")/60/8)>20,"Task >4 weeks late","Task on schedule"))))
As for your issue I cannot reproduce it. I get indicators as expected for all values.
Member for
18 years 5 monthsRE: Graphical Indicators for Variances (Custom Task Field)
First off there is an error in your formula so that it counts weekends into the number of days. Because of this a task that is only really only 19 working days late is shown by your formula to be 27 days late. I have made some adjustments below:
IIf([% Complete]=100,"Task completed",IIf(ProjDateConv([Baseline Finish])="NA","Task not agreed",IIf((ProjDateDiff([Baseline Finish],[Finish],"Standard")/60/8)<=20 And (ProjDateDiff([Baseline Finish],[Finish],"Standard")/60/8)>7,"Task >1 week late",IIf((ProjDateDiff([Baseline Finish],[Finish],"Standard")/60/8)>20,"Task >4 weeks late","Task on schedule"))))
As for your issue I cannot reproduce it. I get indicators as expected for all values.