Different Results using formulas in Customized Fields

[Simmons_RJ]

I have an enterprise number field setup on the Global template that is a
graphical indication of whether a task is late that does not appear to be
working correctly. When I create a customized field local to the plan, the
expected result of the formula is displayed; however when I insert the
enterprise customized field a different/incorrect result appears. The
formula is:

IIf([% Work Complete]=100,4,IIf([% Work
Complete]=0,IIf([Start]<Now()-7,1,IIf([Start]<Now(),2,3)),IIf([% Work
Complete]<100,IIf([Finish]<Now()-7,1,IIf([Finish]<Now(),2,3)))))

Can anyone lend some assistance as to why this is occuring?

Thanks,

Rob

 

[Dale Howard [MVP]]

Rob --

If you insert the custom enterprise field into a project and press the F9
function key, does it now show correct results?

 

[Reid McTaggart]

Just to cover the basics:

1) After defining the Enterprise custom field, did you save Enterprise
Global and then exit and restart Project Pro?

2) Did you recalc [F9] the project plan?

If you answered Yes to both, then please describe the incorrect results you
are getting.

 

[Simmons_RJ]

F9 Did the trick. Thanks!

Rob --

If you insert the custom enterprise field into a project and press the F9
function key, does it now show correct results?

I have an enterprise number field setup on the Global template that is a
graphical indication of whether a task is late that does not appear to be
working correctly. When I create a customized field local to the plan,
the
expected result of the formula is displayed; however when I insert the
enterprise customized field a different/incorrect result appears. The
formula is:

IIf([% Work Complete]=100,4,IIf([% Work
Complete]=0,IIf([Start]<Now()-7,1,IIf([Start]<Now(),2,3)),IIf([% Work
Complete]<100,IIf([Finish]<Now()-7,1,IIf([Finish]<Now(),2,3)))))

Can anyone lend some assistance as to why this is occuring?

Thanks,

Rob