You could also use this formula.....
IIf([Baseline Start]>999999,"No BL",IIf([Baseline
Work]=0,"NA",switch([Work]/[Baseline Work]<1.1,"<10% Over",[Work]/[Baseline
Work]<1.2,"10-20% Over",[Work]/[Baseline Work]>=1.2,">20% Over")))
Graphical Indicators would be something like this with images of your choice:
equals No BL
equals NA
equals <10% Over
equals 10-20% Over
equals >20% Over
is any value <ALL>
--
Project Consultant
Project Server Training Site
http://moss.rejcompany.com:30778/pwat
Paul Conroy said:
Create a Project/Text Custom Field
IIf([Baseline Finish]=ProjDateValue("NA"),0,(([Duration]/[Baseline
Duration])*100))
Then use graphical indicators for the field with the following criteria:
Is greater than or equal to 120 Red dot
Is greater than 100 Yellow dot
Is less than or equal to 100 Green dot
--
Please rate this post if it has helped
http://www.fundraiseonline.co.nz/TheProjectServerGuru/
http://theprojectserverguru.spaces.live.com
Maurizio said:
Paul,
Thank you! I am referring to schedule. I need to create a Work KPI
--
Maurizio Molina
:
Maurizio,
Are you referring to cost variance ?
Paul
--
Please rate this post if it has helped
http://www.fundraiseonline.co.nz/TheProjectServerGuru/
http://theprojectserverguru.spaces.live.com
:
Hi Team,
I need help creating a custom field that reflects the criteria below.
Thanks a bunch!
A key performance indicator (stoplight) that is green if the variance
(Forecast compared to Baseline) is within 10%...yellow if it is within
10-20%....and red if it is greater than 20%.