Share via

Microsoft Project custom field problem

Anonymous
2013-07-27T14:04:12+00:00

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.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. John Project 49,710 Reputation points Volunteer Moderator
    2013-07-27T17:35:58+00:00

    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

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2013-07-27T16:04:11+00:00

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

    Was this answer helpful?

    0 comments No comments
  3. John Project 49,710 Reputation points Volunteer Moderator
    2013-07-27T14:58:04+00:00

    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

    Was this answer helpful?

    0 comments No comments