Prev: Start, Finish and Duration Changes in MS Project 2003?
Next: how can I print start & finish dates
From: External Update on 14 May 2010 10:56
I am pretty weak on formulas but here goes. I have the following formula:
IIf([Duration]=0,(IIf([% Complete]=100,2,IIf([Finish]<Now()+14 And [%
Complete]<100 And [% Complete]>=80,3,IIf([Finish]<Now()+14 And [%
Complete]<80,4,1)))),IIf([% Complete]=100 Or [%
Complete]>100*(Abs((Now()-[Start])/([Finish]-[Start]))),2,(IIf([Finish]>Now(),IIf([Start]>Now(),1,3),4))))

I would like to modify it to add 1.0 to the result if Flag4 = Yes.

Can somebody help.
Thanks
Larry
From: Rob Schneider on 14 May 2010 11:12
Wow. My head hurts trying to figure this out.

I guess what I would do is simply leave this field (let's call it [First
Field] alone and create a new column which computes it's value based on
the value of this column IIF(Flag4=Yes,[First Field]+1],[First Field]

--rms

www.rmschneider.com




On 14/05/10 15:56, External Update wrote:
> IIf([Duration]=0,(IIf([% Complete]=100,2,IIf([Finish]<Now()+14 And [%
> Complete]<100 And [% Complete]>=80,3,IIf([Finish]<Now()+14 And [%
> Complete]<80,4,1)))),IIf([% Complete]=100 Or [%
> Complete]>100*(Abs((Now()-[Start])/([Finish]-[Start]))),2,(IIf([Finish]>Now(),IIf([Start]>Now(),1,3),4))))
From: Andrew Lavinsky on 14 May 2010 11:15
Perhaps you might want to explain what it is you're trying to accomplish.
Just looking at the first line, you appear to be testing milestones to display
a "2" if complete and a "3" if they're between 80% and 100% done. Typically
milestones are 0 or a 100%. I am not sure that I've heard of an 80% done
milestone.

Let us know what you're trying to do, and we may come up with a simpler formula.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

> IIf([Duration]=0,(IIf([% Complete]=100,2,IIf([Finish]<Now()+14 And [%
> Complete]<100 And [% Complete]>=80,3,IIf([Finish]<Now()+14 And [%
> Complete]<80,4,1)))),IIf([% Complete]=100 Or [%
> Complete]>100*(Abs((Now()-[Start])/([Finish]-[Start]))),2,(IIf([Finish
> ]>Now(),IIf([Start]>Now(),1,3),4))))
>


From: Jim Aksel on 14 May 2010 12:57
I am with Andrew on this one .... A milestone marks a change it state, not a
measure of complete. The water is frozen (yes/no), Meeting Minutes Submitted
(Yes/No). As such, the condition of a milestone is a measure of time that
is very very thin.... it is of 0 duration.

Perhaps there are a group of tasks that roll up to this milestone and you
can take a measure of %Complete on those (at the summary task level perhaps).

Looking at the formula, I too have a head ache. I think you are going to
hit a max character limit soon. I think there is a simpler way to do this
.... tell us what you are wanting to accomplish. It looks like you are
returning different integers depending on %Complete and if the finish date is
within 14 business days. This begs the question, what if the Finish date is
not within this range?

Part of your formula looks like it is trying to compare %Complete vs the %
of duration in the task. Project already does this with the "Status" column.
You should probably take a look at my white paper on "What Percent Complete
Should I Be" posted on my blog (below).


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com



"External Update" wrote:

> I am pretty weak on formulas but here goes. I have the following formula:
> IIf([Duration]=0,(IIf([% Complete]=100,2,IIf([Finish]<Now()+14 And [%
> Complete]<100 And [% Complete]>=80,3,IIf([Finish]<Now()+14 And [%
> Complete]<80,4,1)))),IIf([% Complete]=100 Or [%
> Complete]>100*(Abs((Now()-[Start])/([Finish]-[Start]))),2,(IIf([Finish]>Now(),IIf([Start]>Now(),1,3),4))))
>
> I would like to modify it to add 1.0 to the result if Flag4 = Yes.
>
> Can somebody help.
> Thanks
> Larry
 | 
Pages: 1
Prev: Start, Finish and Duration Changes in MS Project 2003?
Next: how can I print start & finish dates