Graphical Indicators for Variances (Custom Task Field)
In the Open Standard
Stephen GradyMember for 23 years 2 months
- Created
- 1
- 4
0
I’ve created a formula which I hoped would show a graphical indicator against the status of each task.
The formula I have used is:
IIf([% Complete]=100,"Task completed",IIf(ProjDateConv([Baseline Finish])="NA","Task not agreed",IIf(([Finish]-[Baseline Finish])<=20 And ([Finish]-[Baseline Finish])>7,"Task >1 week late",IIf(([Finish]-[Baseline Finish])>20,"Task >4 weeks late","Task on schedule"))))
The Graphical fields are:
equals "Task completed" x
equals "Task not agreed" Y
equals "Task on schedule" A
equals "Task >1 week late" B
equals "Task >4 weeks late"C
Obviously I have used symbols from the Image drop down box as opposed to X,Y,A,B & C.
The problem I have is that if a task has a greater varians than 20 days (4 weeks) there is nor graphical representation.
Can anyone advise.
Thanks
Steve
The formula I have used is:
IIf([% Complete]=100,"Task completed",IIf(ProjDateConv([Baseline Finish])="NA","Task not agreed",IIf(([Finish]-[Baseline Finish])<=20 And ([Finish]-[Baseline Finish])>7,"Task >1 week late",IIf(([Finish]-[Baseline Finish])>20,"Task >4 weeks late","Task on schedule"))))
The Graphical fields are:
equals "Task completed" x
equals "Task not agreed" Y
equals "Task on schedule" A
equals "Task >1 week late" B
equals "Task >4 weeks late"C
Obviously I have used symbols from the Image drop down box as opposed to X,Y,A,B & C.
The problem I have is that if a task has a greater varians than 20 days (4 weeks) there is nor graphical representation.
Can anyone advise.
Thanks
Steve
1 reply
Oldest first- 0Brian Ultican ·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.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?