Naomi --
Yes, you could use a custom enterprise task Duration field for this purpose.
If you use a Duration field, you don't need to format the result of your
formula in days. The formula might be something like this:
IIf([Finish Variance]>0,IIf([% Complete]<100,[Finish Variance],0),0)
The above formula tests to see if the Finish Variance field is greater than
0 days. If so, it then tests to see if the % Complete value is less than
100%. If both condititions are true, the formula returns the Finish
Variance value. If one or both conditions are false, then the formula
returns 0. From there, you can build tests for your stoplight indicators to
show the proper indicator if there is Finish Variance greater than 0 days.
If it is 0 days, then show no indicator at all. I have tested this formula,
and it works. Hope this helps.
Naomi Nissen said:
Here's what I'm trying to do. It's fairly simple. If the actual task
is late against the baseline AND if the % complete is less than 100%
(in other words, we're only counted completed tasks), then show it
with a stoplight indicator by number of days.
thanks.
Naomi --
What are you trying to accomplish with this formula? Knowing your intent
would help us to help you. Generally speaking, if you use Duration
Variance
in a formula in a Number field, you have to convert the Duration Variance
value to days. This is because Microsoft Project stores both Work and
Duration values in minutes in the database, and you have to convert them
to
either hours or days. Let us know what you are trying to do with the
formula and we will try to help you.
I'm hoping someone can clarify this for me.
If I want to make a formula that combines a duration function
[variance] which is measured in days, and a % function [% complete],
would I choose a number formula to accomodate both? Or would this not
work at all?
Thanks.
Naomi- Hide quoted text -
- Show quoted text -
