I got the same issue (field names in Enterprise formulas are automatically replaced by some MSPJ identification number which will not work then...).
It took some time to get the idea of Service Pack update. This idea was supported by several other blogs, hence I'm sure this will help you and perhaps soon myself
Regards & good luck,
Karsten
Valeria Chiuki wrote:
Thank you Jonathan for your answer,With this formula I am trying to get the
08-Oct-09
Thank you Jonathan for your answer,
With this formula I am trying to get the "%Complete Planned" for a given
Status date. I am using Baseline 10 to unify the differente baselines that
you can have in all the projects. Baselin 10 allways has a copy of whatever
baseline is using the project.
But the problem is not the formula, is that I cannot save it using PWA. I
tryed using coma instead of colon and it did not work too.
Once I could save it, but when I tryed to modify it, I got all the name of
the fields replaced by "MSPJ".
I am not using Service Pack 1, do you think this would repair it?
Thanks.
:
Previous Posts In This Thread:
Custom fields in Project Server 2007
Hi,
I am trying to customize a field in Project 2007 using PWA and using a
number task type field and I get an error message that indicates "there is a
problem with the sysntax" . The formula is IIf([Baseline >
10Work]=0;IIf([Status Date]<[Baseline10 Start];0;100);([BCWS]/[Baseline 10 >
Work]))
The problem is that if I try the same thing using Microsoft Project Pro, the
formula workf perfectly. The error comes when I tryed to create it with the
PWA to make it a enterprise field.
Any solution?
Thanks!
I don't think this formula you specified below would work in Project Pro
I do not think this formula you specified below would work in Project Pro
either. There are several mistakes in syntax here. My best guess as to
what you are trying to achieve would yield the following formula:
IIf([Baseline10 Work]=0,IIf([Status Date]<[Baseline10
Start],0,100),([BCWS]/[Baseline10 Work]))
But I really have no idea what your formula is trying to achieve. Can you
elaborate a bit?
Also, you should try and add in more logic to handle situations like having
no status date set or no baseline 10 taken. And checking if baseline10 work
= 0 does not necessarily mean there is no baseline set, it could mean that
the work for the task was 0 when the baseline was set.
Jonathan
Thank you Jonathan for your answer,With this formula I am trying to get the
Thank you Jonathan for your answer,
With this formula I am trying to get the "%Complete Planned" for a given
Status date. I am using Baseline 10 to unify the differente baselines that
you can have in all the projects. Baselin 10 allways has a copy of whatever
baseline is using the project.
But the problem is not the formula, is that I cannot save it using PWA. I
tryed using coma instead of colon and it did not work too.
Once I could save it, but when I tryed to modify it, I got all the name of
the fields replaced by "MSPJ".
I am not using Service Pack 1, do you think this would repair it?
Thanks.
:
You can convert a local custom field into an enterprise custom field using
You can convert a local custom field into an enterprise custom field using
Project Professional only.
1) Create your local custom field with the formula and verify that it works
the way you want it to work.
2) Go back to Tools>Customize>Fields and select your local custom field.
3) There you will see a button "Add Field to Enterprise...". This will
allow you to convert the custom field into an enterprise one.
I am assuming you have admin rights.
As for service pack levels, I cannot be certain if this is the issue but it
is always going to be recommended by Microsoft to upgrade your systems to
the latest service packs and in many cases strange issues like this one will
be resolved.
Jonathan
Submitted via EggHeadCafe - Software Developer Portal of Choice
..NET Windows Forms Cursor To Hourglass
http://www.eggheadcafe.com/tutorial...e2-fd2e66d4dbcd/net-windows-forms-cursor.aspx