PWA Custom Field - Date Difference

G

Gertie

In PWA, I am trying to set up an Enterprise Custom Task Field to subtract a
baseline date [Baseline10 Finish] from the current finish date [Finish]. I
have set it up as follows:
Entity = Task
Type = Duration
Formula - [Baseline10 Finish]-[Finish]

I am able to save the formula and I have created a PWA Project view that
includes the new field. However, the column for the new field is blank
although the [Baseline10 Finish] field and the [Finish] field contain data.

What is going wrong, please?
 
G

Gérard Ducouret

Hi Gertie,

Did you re-publish the projects in Project Pro after creating the custom
fileld ?

Gérard Ducouret
 
D

Dale Howard [MVP]

Gertie --

You are doing two things wrong. First of all, I would recommend you use the
ProjDateDiff function to calculate your variance. Assuming you are using
the enterprise Standard calendar as the Project Calendar for most of your
organization's enterprise projects, the formula would be as follows:

ProjDateDiff([Baseline10 Finish],[Finish],"Standard")

If you are using a different enterprise calendar for most of your
organization's projects, then use that calendar's name in the above formula.

The second thing you need to do is to ask your PMs to open each one of their
enterprise projects, to press the F9 function key to recalculate the
project, and then to save AND publish their project. You should now see the
information in the custom field in your custom PWA view. Hope this helps.
 

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

Top