Project 2000 - Probelm with user defined cost field

[Lloyd Williams]

Hello,

I use a user defined attribute field "attribute 1" with allowed values
(yes; no) and a user defined cost field "cost 1" with a formular
"IIf(attribute 1;cost;0)". So basically, if I choose "yes", the
original task costs are copied into the "cost 1" field. the summary
tasks sum up all the "cost 1" fields.

This all works pretty well but when I close the file, re-open it and
change a field from "yes" to "no", MS Project starts recalculating the
whole project...and won't stop. It calculates until forever. Plus the
formular in the "cost 1" fields is not updated but remains on the old
value. What is going on? Is it a bug?

Please help, thanks,

Lloyd.

 

[JulieS]

Hi Lloyd,

I don't have Project 2000 nearby to test, but when I tried using the formula
in both Project 2002 and Project 2003 as you describe it, the result of the
formula is always the [Cost] field. I modified the formula as follows:
(Note the "Attribute 1" custom field is the [Text1] field with a value list
of "yes" or "no".)

IIf([Text1]="Yes",[Cost],0)

This seems to calculate correctly and I have not experienced the long
calculation time you note.

Hope this helps. Let us know how you get along.

Julie