Using Project level custom fields in Views 2007

N

Nik003

On Project Server 2007:

When creating custom fields at the project level, based on formulas, the
formula works just fine in project properties, but when putting that field in
a custom view, the value is not the result of the formula, but rather a weird
number. Is it possible that it's not performing the calculation, but rather,
I don't know, adding the numeric values of all characters in the formula or
something?

Is there a way to fix this? Or is it a bug?

Thanks.
 
M

Marc Soester [MVP]

Hi Nik003,

Generally when you create a formula custom field, then you can use that in
custom views ( I assume you are talking about custom views in PWA).
If you sent the formula I can test it here and see if I get the same result
Thanks
 
N

Nik003

The formula is as simple as it gets:

([Actual Work]+[Remaining Work])

It calculates just fine in the Project Properties, but in the view it bombs.

Thanks.
 
J

Jonathan Sofer

Correct me if I'm wrong Nik but your formula is just the definition of the
[Work] field in Project Pro. Why not just use out-of-the-box [Work] field
since it will always equal the same value as your custom formula.

BTW, does your custom formula show up correctly in Projet Pro views?

Jonathan

Nik003 said:
The formula is as simple as it gets:

([Actual Work]+[Remaining Work])

It calculates just fine in the Project Properties, but in the view it
bombs.

Thanks.

Marc Soester said:
Hi Nik003,

Generally when you create a formula custom field, then you can use that
in
custom views ( I assume you are talking about custom views in PWA).
If you sent the formula I can test it here and see if I get the same
result
Thanks
Click to expand...
Click to expand...
 
M

Marc Soester [MVP]

Hi Nick,

Why dont you use the field "Work" which is essentially Actual Work +
Remaining Work.


--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


Nik003 said:
The formula is as simple as it gets:

([Actual Work]+[Remaining Work])

It calculates just fine in the Project Properties, but in the view it bombs.

Thanks.

Marc Soester said:
Hi Nik003,

Generally when you create a formula custom field, then you can use that in
custom views ( I assume you are talking about custom views in PWA).
If you sent the formula I can test it here and see if I get the same result
Thanks
Click to expand...
Click to expand...
 
N

Nik003

duhh :)

Thanks guys.

Marc Soester said:
Hi Nick,

Why dont you use the field "Work" which is essentially Actual Work +
Remaining Work.


--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


Nik003 said:
The formula is as simple as it gets:

([Actual Work]+[Remaining Work])

It calculates just fine in the Project Properties, but in the view it bombs.

Thanks.

Marc Soester said:
Hi Nik003,

Generally when you create a formula custom field, then you can use that in
custom views ( I assume you are talking about custom views in PWA).
If you sent the formula I can test it here and see if I get the same result
Thanks
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


:

On Project Server 2007:

When creating custom fields at the project level, based on formulas, the
formula works just fine in project properties, but when putting that field in
a custom view, the value is not the result of the formula, but rather a weird
number. Is it possible that it's not performing the calculation, but rather,
I don't know, adding the numeric values of all characters in the formula or
something?

Is there a way to fix this? Or is it a bug?

Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Top