Microsoft Project custom field problem

Question

Hello,

I am trying to track changes on the CPI and SPI once the baseline has been set. I have created a custom field number column. I have applied graphical indicators and they do not pick up the value correctly in the summary and non summary tasks, in addition some columns have errors in them as there is no costs attached to those tasks. i have tried this formula below but to no avail, I do not know what is going wrong

CPI:   IIf(([Baseline Cost]="£0"),">1",[CPI])

SPI:   IIf(([Baseline Duration]="0"),"0",[SPI])

I wanted to the Baseline to pick up the 0 values and put NA, otherwise i want it to calculate the SPI or the CPI. Something along those lines.

Please help, i do not know how to rectify my mistakes.

Answer 1

hsingh333,

Actually SP2 was just released so I suggest you install it, however, that will not resolve your problem.

First, is your file a single project file or is it part of a linked structure (i.e. master/subproject, etc.)?

When you say it's not working, what is it showing in the Text1 & Text2 fields? Simply saying "it's not working" doesn't tell me anything.

John

Answer 2

I am using Microsoft Project 2010 and service pack 1. I have tried those 2 formulas. Its not working for some reason.

Answer 3

hsingh333,

First of all, what version of Project are you using? Is it updated with the latest service pack?

You indicate your custom field is a number field however number fields can only contain numerical values (i.e. the ">1" will produce an error). And if you want the formula to produce an "NA", then a custom text field is what you need. Try the following custom fields:

Text1=IIf([Baseline Cost]=0,"NA",[CPI])

Text2=IIf([Baseline Duration]=0,"NA",[SPI])

If you want those formula to also calculate at summary level, check the option to "use formula" for calculation of task and group summary rows.

Hope this helps.

John