Formula which disappear when move from Professonal to Server

[JABAR]

We use MS Professional and Project Server 2007.
First problem
Formula which are define in Professional disappear or destroy when we move
from Professional to Server and back. It’s look like Project Server don’t
understand formula Professional and change or delete it.
Example
We define column ‘cost’ in Professional CCur(IIf([Praca wg
pbaz.]<>0;IIf([Group of resource]='K';400*[Baseline work time]/480;0);0)) lub
IIf([baseline work]<>0;IIf([Group of resource]='K';400*[Baseline work
time]/480;0);0). The Project Professional works well, but Project Server
(after publish) delete this formula, which we see when we take project back
to Professional.

Second problem
The formula in Professional for ex ‘130,25’ it’s change to ‘130;25’ when we
move to Project Server and back project from Server to professional.

Thanks for any help
Jacek & Agnieszka

 

[Lars Kragh-Hansen]

First issue:
Have you copied the view with the formula to the enterprise global?
Open the project in which you have entered the formula AND open the
enterprise global
Copy the view from the project to the enterprise global by using the Organizer

Second:
Your experience with "," being changed into ";" could be due to the fact
that regional settings are not set to the same in both your ProjectServer and
the Project client.


Hope this helps

Lars

 

[JABAR]

Hi Lars, thanks for the response

In case 1 we do it like you suggest but after then formula was change to:

CCur(IIf([MSPJ188743682]<>0;IIf([MSPJ188743793]='K';400*[MSPJ188743708]/480;0);0))
- magic change... – we don’t understand what is going on.

(( - have you any other idea ?

Thansk fo cas 2 - it's works !

Thanks
Jacek & Agnieszka

First issue:
Have you copied the view with the formula to the enterprise global?
Open the project in which you have entered the formula AND open the
enterprise global
Copy the view from the project to the enterprise global by using the Organizer

Second:
Your experience with "," being changed into ";" could be due to the fact
that regional settings are not set to the same in both your ProjectServer and
the Project client.


Hope this helps

Lars

We use MS Professional and Project Server 2007.
First problem
Formula which are define in Professional disappear or destroy when we move
from Professional to Server and back. It’s look like Project Server don’t
understand formula Professional and change or delete it.
Example
We define column ‘cost’ in Professional CCur(IIf([Praca wg
pbaz.]<>0;IIf([Group of resource]='K';400*[Baseline work time]/480;0);0)) lub
IIf([baseline work]<>0;IIf([Group of resource]='K';400*[Baseline work
time]/480;0);0). The Project Professional works well, but Project Server
(after publish) delete this formula, which we see when we take project back
to Professional.

Second problem
The formula in Professional for ex ‘130,25’ it’s change to ‘130;25’ when we
move to Project Server and back project from Server to professional.

Thanks for any help
Jacek & Agnieszka

 

[Lars Kragh-Hansen]

Hi Jacek & Agniezka,


Regarding your first issue:
It seems Project translate the elements of the formula into a
Project-universal code. This may due to the previous different Regional
Settings. As formula elements are named differently in different languages,
it is my guess is that [MSPJ188743793] equals [Resource Group] etc..

Have you tried the process after having both server and client environment
set to the same regional setting?

If the above does not solve your question, I am afraid I have run out of
ideas about what could be the root cause.


Best Regards,

Lars

Hi Lars, thanks for the response

In case 1 we do it like you suggest but after then formula was change to:

CCur(IIf([MSPJ188743682]<>0;IIf([MSPJ188743793]='K';400*[MSPJ188743708]/480;0);0))
- magic change... – we don’t understand what is going on.

(( - have you any other idea ?

Thansk fo cas 2 - it's works !

Thanks
Jacek & Agnieszka

First issue:
Have you copied the view with the formula to the enterprise global?
Open the project in which you have entered the formula AND open the
enterprise global
Copy the view from the project to the enterprise global by using the Organizer

Second:
Your experience with "," being changed into ";" could be due to the fact
that regional settings are not set to the same in both your ProjectServer and
the Project client.


Hope this helps

Lars

We use MS Professional and Project Server 2007.
First problem
Formula which are define in Professional disappear or destroy when we move
from Professional to Server and back. It’s look like Project Server don’t
understand formula Professional and change or delete it.
Example
We define column ‘cost’ in Professional CCur(IIf([Praca wg
pbaz.]<>0;IIf([Group of resource]='K';400*[Baseline work time]/480;0);0)) lub
IIf([baseline work]<>0;IIf([Group of resource]='K';400*[Baseline work
time]/480;0);0). The Project Professional works well, but Project Server
(after publish) delete this formula, which we see when we take project back
to Professional.

Second problem
The formula in Professional for ex ‘130,25’ it’s change to ‘130;25’ when we
move to Project Server and back project from Server to professional.

Thanks for any help
Jacek & Agnieszka

 

[JABAR]

Great THANKS for help ! It's works !

We have to wait for our administrator to change parameters and now is OK.
Thanks

Hi Jacek & Agniezka,


Regarding your first issue:
It seems Project translate the elements of the formula into a
Project-universal code. This may due to the previous different Regional
Settings. As formula elements are named differently in different languages,
it is my guess is that [MSPJ188743793] equals [Resource Group] etc..

Have you tried the process after having both server and client environment
set to the same regional setting?

If the above does not solve your question, I am afraid I have run out of
ideas about what could be the root cause.


Best Regards,

Lars

Hi Lars, thanks for the response

In case 1 we do it like you suggest but after then formula was change to:

CCur(IIf([MSPJ188743682]<>0;IIf([MSPJ188743793]='K';400*[MSPJ188743708]/480;0);0))
- magic change... – we don’t understand what is going on.

(( - have you any other idea ?

Thansk fo cas 2 - it's works !

Thanks
Jacek & Agnieszka

First issue:
Have you copied the view with the formula to the enterprise global?
Open the project in which you have entered the formula AND open the
enterprise global
Copy the view from the project to the enterprise global by using the Organizer

Second:
Your experience with "," being changed into ";" could be due to the fact
that regional settings are not set to the same in both your ProjectServer and
the Project client.


Hope this helps

Lars


:

We use MS Professional and Project Server 2007.
First problem
Formula which are define in Professional disappear or destroy when we move
from Professional to Server and back. It’s look like Project Server don’t
understand formula Professional and change or delete it.
Example
We define column ‘cost’ in Professional CCur(IIf([Praca wg
pbaz.]<>0;IIf([Group of resource]='K';400*[Baseline work time]/480;0);0)) lub
IIf([baseline work]<>0;IIf([Group of resource]='K';400*[Baseline work
time]/480;0);0). The Project Professional works well, but Project Server
(after publish) delete this formula, which we see when we take project back
to Professional.

Second problem
The formula in Professional for ex ‘130,25’ it’s change to ‘130;25’ when we
move to Project Server and back project from Server to professional.

Thanks for any help
Jacek & Agnieszka