PWA Custom Field - Date Difference

[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érard Ducouret]

Hi Gertie,

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

Gérard Ducouret

 

[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.