M
Marcus Pierce
All,
I have the same exact formula in two different custom fields: The first is
in Enterprise Task Number 1, the second is in Enterprise Project Number 1. It
works in the first but not the latter. When I go into a project and show
those two columns (for the custom fields) the first shows the correct
results, indicated by the graphical indicators that I specified, but the
latter results in an error. Does any one know why the Task field works but
the Project field doesn't?
I'm using Project 2003 Pro. The formula is:
IIf([Baseline Cost]=0,0,(IIf([Cost]=0,1,IIf([Cost]<([Baseline
Cost]*1.2),IIf([Cost]<([Baseline Cost]*1.05),1,2),3))))
Is this because Baseline Cost and Cost are Task-level fields or something?
What field(s) should I use to show project-level cost status?
Thanks.
--Marcus
I have the same exact formula in two different custom fields: The first is
in Enterprise Task Number 1, the second is in Enterprise Project Number 1. It
works in the first but not the latter. When I go into a project and show
those two columns (for the custom fields) the first shows the correct
results, indicated by the graphical indicators that I specified, but the
latter results in an error. Does any one know why the Task field works but
the Project field doesn't?
I'm using Project 2003 Pro. The formula is:
IIf([Baseline Cost]=0,0,(IIf([Cost]=0,1,IIf([Cost]<([Baseline
Cost]*1.2),IIf([Cost]<([Baseline Cost]*1.05),1,2),3))))
Is this because Baseline Cost and Cost are Task-level fields or something?
What field(s) should I use to show project-level cost status?
Thanks.
--Marcus