Project formulas

[David Luper]

Hi all!

I am working on a new report, and I need some formula help.

Essentially, we want Physical % Complete to be a weighted value driven by
the completion of project "gates" determined by entering a date value. We
will use this Physicial % Complete value for custom Earned Value calculations.

So, here is where I am -

I have created four custom date fields (Date1 through Date4). I intend to
have the PMs enter dates into these fields when the tasks (which are really
deliverables) are complete. I want each to kick off a certain amount of %
complete (i.e., Date1 = 50%, Date2=25% (a total of 75%), Date3=10% (a total
of 85%) and so on. Otherwise, the value in the field would be N/A. I want
the Physical % Complete to automatically generate and sum up in the summary
tasks when dates are entered into Date1-Date4.

I have tried IIf and CountAs functions, and they don't deliver the results I
want (although it is highly possible I am doing it incorrectly).

Any help would be appreciated!

Thanks!
David

 

[David Luper]

Does no one have any ideas? I still haven't got this to work satisfactorily.
Or, if anyone has an approach that you think would be better, I would love
to hear of it.

Thanks!
David

 

[Dale Howard [MVP]]

David --

The reason no one has answered, I believe, is because you cannot do what you
wish using a formula. First of all, the Phyiscal % Complete field is a
standard field, not a custom field, so you cannot enter a formula in that
field. Instead, to do what you wish, you would need to create a macro using
Project VBA code. If this is what you are willing to do, you should post
your question in the microsoft.public.project.developer newsgroup, as you
are more likely to get an answer there. Hope this helps.

 

[David Luper]

Dale,

Thanks for the response.

Cheers!
David

David --

The reason no one has answered, I believe, is because you cannot do what you
wish using a formula. First of all, the Phyiscal % Complete field is a
standard field, not a custom field, so you cannot enter a formula in that
field. Instead, to do what you wish, you would need to create a macro using
Project VBA code. If this is what you are willing to do, you should post
your question in the microsoft.public.project.developer newsgroup, as you
are more likely to get an answer there. Hope this helps.