Custom fields with formulas

R

Robert

Hello,
How to create custom fields with formulas in PWA 2007?
I tried to create 3 custom fields with a formula in each of them. I
succeeded for one of them, but the 2 others are still empty when I look at
them in Project Pro : their formula is empty.
Thanks for any help
 
R

Robert

NB : While the formula area is empty in Project Pro, the formula area in PWA
contains strange field names like:
ProjDateAdd([MSPJ188743715];[MSPJ188776457])
Any idea ?
 
M

Marc Soester [MVP]

Hi Robert,

as you know in Project Server 2007 the enterprise formulas are managed in
Project Web Access.
Did you validate the formula wihtin MS Project? When you save a Project MS
Project opens up validating the formula. If this did nothappen, the formula
you entered may contain a syntax error,
The numbers that you see in your formula are a database reference to this
custom field. I would re-enter the name of the custom fields, then let MS
Project validate the formula ( when saving the formula) this may resolve your
issue
Hope this helps
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


Robert said:
NB : While the formula area is empty in Project Pro, the formula area in PWA
contains strange field names like:
ProjDateAdd([MSPJ188743715];[MSPJ188776457])
Any idea ?

Robert said:
Hello,
How to create custom fields with formulas in PWA 2007?
I tried to create 3 custom fields with a formula in each of them. I
succeeded for one of them, but the 2 others are still empty when I look at
them in Project Pro : their formula is empty.
Thanks for any help
Click to expand...
Click to expand...
 
R

Robert

Hi Mark,

Yes, I did everything you said. I validated the formulas and MS Project Pro
opened up. I re-entered several times the names of the custom fields, then
let MS Project validate the formulas ...
I noticed that if I embed my formula into a IIF function with a dummy test,
I can save the more complicate formula and I can retrieve it.

Robert

Marc Soester said:
Hi Robert,

as you know in Project Server 2007 the enterprise formulas are managed in
Project Web Access.
Did you validate the formula wihtin MS Project? When you save a Project MS
Project opens up validating the formula. If this did nothappen, the
formula
you entered may contain a syntax error,
The numbers that you see in your formula are a database reference to this
custom field. I would re-enter the name of the custom fields, then let MS
Project validate the formula ( when saving the formula) this may resolve
your
issue
Hope this helps
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


Robert said:
NB : While the formula area is empty in Project Pro, the formula area in
PWA
contains strange field names like:
ProjDateAdd([MSPJ188743715];[MSPJ188776457])
Any idea ?

Robert said:
Hello,
How to create custom fields with formulas in PWA 2007?
I tried to create 3 custom fields with a formula in each of them. I
succeeded for one of them, but the 2 others are still empty when I look
at
them in Project Pro : their formula is empty.
Thanks for any help
Click to expand...
Click to expand...
Click to expand...
 
M

Mvisscher

When saving a custom formula with indicator in PWA, MS project validates ok.

the formula is:
Switch([Baseline Finish]=ProjDateValue("NA"),"No
baseline",([Work]+1)/([Baseline work]+1)>1.1,"More then 10% over
budget",([Work]+1)/([Baseline work]+1)>1,"1 to 10% over budget",True,"On
budget")

When editing the same custom field again always the message 'automatic
reboot of Microsoft project professional could not be completed. Contact you
administrator for
assitance' when MS project is open is displayed, followed by 'The formula
contains a syntax error or contains a reference to an unrecognized field or
function name'.

The formula is now:
Switch([MSPJ188743724]=ProjDateValue("NA");"No
baseline";([MSPJ188743680]+1)/([MSPJ188743681]+1)>1,1;"More then 10% over
budget";([MSPJ188743680]+1)/([MSPJ188743681]+1)>1;"1 to 10% over
budget";True;"On budget")

As you can see, the , are replaced by ;. Is this due to the language
setiings of sharepoint, they are in English (US), but the ; is the default
seperator used in Europe?

What is causing this?

Also it is very annoying, that you are not able the originally entered
formula, but the MSPJ188743681 numbers instead.

Thanks in advance,
Marcel.
 
Top