#Error in Enterprise Custom Fields

[Bill Mc]

OK, this one has me really perplexed. I'm using Project Server 2007:

I've got some local custom fields that I want to move to the Enterprise. I
go into the Custom Fields dialog box in Project Pro 2007 and click the "Add
to Enterprise" button for the fields and they seem to add to the enterprise
fine. However, when I re-open the plan, and insert the enterprise custom
fields, they have "#ERROR" as the value in the custom field. The local
custom fields contain the correct value. the fields in question as formula
fields in which I'm trying to capture the year and month of the finish date
for use in some reporting in PWA. I needed to make them enterprise fields
because i need to do some grouping by those fields and you can't group by
local custom fields in PWA views. The formula that I'm using is

STR(Year([Finish]))+"-"+STR(Month([Finish]))

It works fine as local custom fields but not as Enterprise. Any suggestions??

Thanks

 

[Dale Howard [MVP]]

Bill --

Press the F9 function key to recalculate the project. Does this make the
#Error go away? Let us know.

 

[Bill Mc]

Dale,
Yes, that solved it. To think i was pulling my hair out over something so
small.......

Thanks very much.
Bill


--
Bill McGrath PMP

Bill --

Press the F9 function key to recalculate the project. Does this make the
#Error go away? Let us know.

OK, this one has me really perplexed. I'm using Project Server 2007:

I've got some local custom fields that I want to move to the Enterprise.
I
go into the Custom Fields dialog box in Project Pro 2007 and click the
"Add
to Enterprise" button for the fields and they seem to add to the
enterprise
fine. However, when I re-open the plan, and insert the enterprise custom
fields, they have "#ERROR" as the value in the custom field. The local
custom fields contain the correct value. the fields in question as
formula
fields in which I'm trying to capture the year and month of the finish
date
for use in some reporting in PWA. I needed to make them enterprise fields
because i need to do some grouping by those fields and you can't group by
local custom fields in PWA views. The formula that I'm using is

STR(Year([Finish]))+"-"+STR(Month([Finish]))

It works fine as local custom fields but not as Enterprise. Any
suggestions??

Thanks

 

[Dale Howard [MVP]]

Bill --

You are more than welcome, my friend! It's always the small things that
hurt us the most, like the Ebola virus...

Dale,
Yes, that solved it. To think i was pulling my hair out over something so
small.......

Thanks very much.
Bill


--
Bill McGrath PMP

Bill --

Press the F9 function key to recalculate the project. Does this make the
#Error go away? Let us know.

OK, this one has me really perplexed. I'm using Project Server 2007:

I've got some local custom fields that I want to move to the
Enterprise.
I
go into the Custom Fields dialog box in Project Pro 2007 and click the
"Add
to Enterprise" button for the fields and they seem to add to the
enterprise
fine. However, when I re-open the plan, and insert the enterprise
custom
fields, they have "#ERROR" as the value in the custom field. The local
custom fields contain the correct value. the fields in question as
formula
fields in which I'm trying to capture the year and month of the finish
date
for use in some reporting in PWA. I needed to make them enterprise
fields
because i need to do some grouping by those fields and you can't group
by
local custom fields in PWA views. The formula that I'm using is

STR(Year([Finish]))+"-"+STR(Month([Finish]))

It works fine as local custom fields but not as Enterprise. Any
suggestions??

Thanks