Formula Syntax Question

[Marc]

I am trying to create a formula to help me quickly identify tasks that are
scheduled to finish (using the "finish" field) beyond the Baseline Finish. I
have that formula and it works, here it is:

DateDiff("d",[Baseline Finish],[Finish])

However, if the task is already 100% complete (using the '% complete'
field), I don't want to see any value in the field. Basically, it would only
create a value for those tasks that are NOT complete.

Can anyone help me finish the formula?

 

[Dale Howard [MVP]]

Marc --

If you are wanting to find tasks that are scheduled to finish late and are
not yet completed, I believe you could better use a custom Fiter for this
purpose. Here's how to create it:

1. Click Project - Filtered For - More Filters
2. Click the New button
3. Name the filter something like "Incomplete Late Tasks"
4. Set the filter criteria as follows:

And/Or Field Name Test Value(s)
Finish Variance Is greater than 0
And % Complete Is less than 100%

5. Select the "Show related summary rows" option
6. Click OK
7. Click Apply

If you want to use this Filter in all current and future projects, copy it
to your Global.mpt file using Tools - Organizer - Filters. Just a thought.
Hope this helps.

 

[Jan De Messemaeker]

Hi,

Iif(([% Complete]<100);DateDiff("d",[Baseline Finish],[Finish]);0)
HTH

 

[Mike Glen]

Hi Marc,

Welcome to this Microsoft Project newsgroup

Try:
IIf([%Complete]=100,"",DateDiff("d",[Baseline Finish],[Finish]))


FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[Marc]

Thanks to all!

Hi,

Iif(([% Complete]<100);DateDiff("d",[Baseline Finish],[Finish]);0)
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm

I am trying to create a formula to help me quickly identify tasks that are
scheduled to finish (using the "finish" field) beyond the Baseline Finish. I
have that formula and it works, here it is:

DateDiff("d",[Baseline Finish],[Finish])

However, if the task is already 100% complete (using the '% complete'
field), I don't want to see any value in the field. Basically, it would only
create a value for those tasks that are NOT complete.

Can anyone help me finish the formula?