PS 2007 Need help creating a formula for a custom field

M

Maurizio

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%.
 
R

Robert

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
 
P

Paul Conroy

If duration is your KPI then this formula is not suitable as there items that
can increase duration that are not work.

--
Please rate this post if it has helped

http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com


Robert said:
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%.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top