numerical analysis on duration

Y

yeliab

Using PP and PWA 2007.

I have a need to analyze duration info numerically and have been
unsuccessful with custom fields so far. Specifically I need to:

1. calc baseline contingency (deadline - base finish)
2. calc actual contingency (deadline - finish)
3. calc contingency exhausted (item 1 - (1-2))
4. calc percent contingency exhausted (item 3 / item 1)
5. calc timeline saving opportunities (duration - leveling delay)

In the past, I have tried the datediff and projdatediff functions when
creating custom number fields for these needs. These failed miserably when
attempting to import to enterprise causing metadata sync issues and think
this is due to a data type mismatches. Boiling it down, I want to find a way
to convert duration to a number so I can perform simple math via custom
number fields in PP and PWA. Ideas?
 
M

Mike Glen

Hi yeliab ,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

numerical analysis on duration 0
What are my options for applying a cost contingency/reserve? 2
Weighted % Complete calculation 1
Custom Fields/Formulas Receiving an error "NA" in Project Center 0
Use custom durations 1-10 with deadline to see start dates on gant 7
Custom fields with duration to show contingency 3
how to stop displaying field in project professional 2007 save dia 4
Actual Duration versus Duration 3

Top