Enterprise Custom Fields

[ayus]

Hi Guys,

I'm having problems in creating Enterprise custom fields in
Enterprise Global Template.

My MD has an issue with the naming convention of some fields like
Baseline Work, Baseline cost etc. to Budgeted Work and Budgeted Cost.
I was able to map an enterprise custom field to the baseline cost by
inserting baseline cost in the formular dialog box, but when i tried
doing the same thing for Baseline Work, it didnt work.

Can anyone help me please?

Cheers,
Ayowole

 

[Dale Howard [MVP]]

Ayowole --

Place the following formula in a Number field:

[Baseline Work]/60

Or place the following formula in a Text field:

cStr([Baseline Work]/60" & "h"

Hope this helps.

 

[ayus]

Ayowole --

Place the following formula in a Number field:

[Baseline Work]/60

Or place the following formula in a Text field:

cStr([Baseline Work]/60" & "h"

Hope this helps.

Hi Guys,

I'm having problems in creating Enterprise custom fields in
Enterprise Global Template.

My MD has an issue with the naming convention of some fields like
Baseline Work, Baseline cost etc. to Budgeted Work and Budgeted Cost.
I was able to map an enterprise custom field to the baseline cost by
inserting baseline cost in the formular dialog box, but when i tried
doing the same thing for Baseline Work, it didnt work.

Can anyone help me please?

Cheers,
Ayowole- Hide quoted text -

- Show quoted text -

Dale,

Thanks for your response. I tried the formulars you gave me but when i
copied and pasted cStr([Baseline Work]/60" & "h" in a Text field, it
gave a syntax error. Also the figure showing on the number field is
wrong. Instead of 16 it was showing 960 even (I pasted [Baseline Work]/
60 in the number field)

Do i need to do anything else?

Thanks,
Ayowole

 

[Gary L. Chefetz [MVP]]

Ayus:

Dale made a slight typo. Try this: cStr([Work]/60) & "h"

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

Ayowole --

Place the following formula in a Number field:

[Baseline Work]/60

Or place the following formula in a Text field:

cStr([Baseline Work]/60" & "h"

Hope this helps.

Hi Guys,

I'm having problems in creating Enterprise custom fields in
Enterprise Global Template.

My MD has an issue with the naming convention of some fields like
Baseline Work, Baseline cost etc. to Budgeted Work and Budgeted Cost.
I was able to map an enterprise custom field to the baseline cost by
inserting baseline cost in the formular dialog box, but when i tried
doing the same thing for Baseline Work, it didnt work.

Can anyone help me please?

Cheers,
Ayowole- Hide quoted text -

- Show quoted text -

Dale,

Thanks for your response. I tried the formulars you gave me but when i
copied and pasted cStr([Baseline Work]/60" & "h" in a Text field, it
gave a syntax error. Also the figure showing on the number field is
wrong. Instead of 16 it was showing 960 even (I pasted [Baseline Work]/
60 in the number field)

Do i need to do anything else?

Thanks,
Ayowole

 

[ayus]

Ayus:

Dale made a slight typo. Try this: cStr([Work]/60) & "h"

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

Ayowole --
Place the following formula in a Number field:
[Baseline Work]/60
Or place the following formula in a Text field:
cStr([Baseline Work]/60" & "h"
Hope this helps.


Hi Guys,
I'm having problems in creating Enterprise custom fields in
Enterprise Global Template.
My MD has an issue with the naming convention of some fields like
Baseline Work, Baseline cost etc. to Budgeted Work and Budgeted Cost.
I was able to map an enterprise custom field to the baseline cost by
inserting baseline cost in the formular dialog box, but when i tried
doing the same thing for Baseline Work, it didnt work.
Can anyone help me please?
Cheers,
Ayowole- Hide quoted text -
- Show quoted text -

Dale,

Thanks for your response. I tried the formulars you gave me but when i
copied and pasted cStr([Baseline Work]/60" & "h" in a Text field, it
gave a syntax error. Also the figure showing on the number field is
wrong. Instead of 16 it was showing 960 even (I pasted [Baseline Work]/
60 in the number field)

Do i need to do anything else?

Thanks,
Ayowole- Hide quoted text -

- Show quoted text -

Gary,

I used cStr([Work]/60) & "h" in the text field and i didnt get a
syntax error, however #ERROR displayed in the view.

What am i doing wrong?

 

[Gary L. Chefetz [MVP]]

Into what specific field are you entering the formula? Did you press F9 to
recalculate the project?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

Ayus:

Dale made a slight typo. Try this: cStr([Work]/60) & "h"

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

On Jul 23, 2:23 pm, "Dale Howard [MVP]"
<dale(dot)howard(at)msprojecexperts(dot)com> wrote:
Ayowole --

Place the following formula in a Number field:

[Baseline Work]/60

Or place the following formula in a Text field:

cStr([Baseline Work]/60" & "h"

Hope this helps.

Hi Guys,

I'm having problems in creating Enterprise custom fields in
Enterprise Global Template.

My MD has an issue with the naming convention of some fields like
Baseline Work, Baseline cost etc. to Budgeted Work and Budgeted
Cost.
I was able to map an enterprise custom field to the baseline cost
by
inserting baseline cost in the formular dialog box, but when i tried
doing the same thing for Baseline Work, it didnt work.

Can anyone help me please?

Cheers,
Ayowole- Hide quoted text -

- Show quoted text -

Dale,

Thanks for your response. I tried the formulars you gave me but when i
copied and pasted cStr([Baseline Work]/60" & "h" in a Text field, it
gave a syntax error. Also the figure showing on the number field is
wrong. Instead of 16 it was showing 960 even (I pasted [Baseline Work]/
60 in the number field)

Do i need to do anything else?

Thanks,
Ayowole- Hide quoted text -

- Show quoted text -

Gary,

I used cStr([Work]/60) & "h" in the text field and i didnt get a
syntax error, however #ERROR displayed in the view.

What am i doing wrong?

 

[ayus]

Into what specific field are you entering the formula? Did you press F9 to
recalculate the project?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

Ayus:
Dale made a slight typo. Try this: cStr([Work]/60) & "h"
--
Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

On Jul 23, 2:23 pm, "Dale Howard [MVP]"
<dale(dot)howard(at)msprojecexperts(dot)com> wrote:
Ayowole --
Place the following formula in a Number field:
[Baseline Work]/60
Or place the following formula in a Text field:
cStr([Baseline Work]/60" & "h"
Hope this helps.


Hi Guys,
I'm having problems in creating Enterprise custom fields in
Enterprise Global Template.
My MD has an issue with the naming convention of some fields like
Baseline Work, Baseline cost etc. to Budgeted Work and Budgeted
Cost.
I was able to map an enterprise custom field to the baseline cost
by
inserting baseline cost in the formular dialog box, but when i tried
doing the same thing for Baseline Work, it didnt work.
Can anyone help me please?
Cheers,
Ayowole- Hide quoted text -
- Show quoted text -
Dale,
Thanks for your response. I tried the formulars you gave me but when i
copied and pasted cStr([Baseline Work]/60" & "h" in a Text field, it
gave a syntax error. Also the figure showing on the number field is
wrong. Instead of 16 it was showing 960 even (I pasted [Baseline Work]/
60 in the number field)
Do i need to do anything else?
Thanks,
Ayowole- Hide quoted text -
- Show quoted text -

Gary,

I used cStr([Work]/60) & "h" in the text field and i didnt get a
syntax error, however #ERROR displayed in the view.

What am i doing wrong?- Hide quoted text -

- Show quoted text -

Gary,

I pasted the formular into a text type and i ticked resource ( There
are 3 options- Task, Resource and Project)

Thanks

 

[Gary L. Chefetz [MVP]]

Try selecting task.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

Into what specific field are you entering the formula? Did you press F9
to
recalculate the project?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

Ayus:

Dale made a slight typo. Try this: cStr([Work]/60) & "h"

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting:http://www.msprojectexperts.com
For Project Server FAQS:http://www.projectserverexperts.com

On Jul 23, 2:23 pm, "Dale Howard [MVP]"
<dale(dot)howard(at)msprojecexperts(dot)com> wrote:
Ayowole --

Place the following formula in a Number field:

[Baseline Work]/60

Or place the following formula in a Text field:

cStr([Baseline Work]/60" & "h"

Hope this helps.

Hi Guys,

I'm having problems in creating Enterprise custom fields in
Enterprise Global Template.

My MD has an issue with the naming convention of some fields like
Baseline Work, Baseline cost etc. to Budgeted Work and Budgeted
Cost.
I was able to map an enterprise custom field to the baseline
cost
by
inserting baseline cost in the formular dialog box, but when i
tried
doing the same thing for Baseline Work, it didnt work.

Can anyone help me please?

Cheers,
Ayowole- Hide quoted text -

- Show quoted text -

Dale,

Thanks for your response. I tried the formulars you gave me but when
i
copied and pasted cStr([Baseline Work]/60" & "h" in a Text field, it
gave a syntax error. Also the figure showing on the number field is
wrong. Instead of 16 it was showing 960 even (I pasted [Baseline
Work]/
60 in the number field)

Do i need to do anything else?

Thanks,
Ayowole- Hide quoted text -

- Show quoted text -

Gary,

I used cStr([Work]/60) & "h" in the text field and i didnt get a
syntax error, however #ERROR displayed in the view.

What am i doing wrong?- Hide quoted text -

- Show quoted text -

Gary,

I pasted the formular into a text type and i ticked resource ( There
are 3 options- Task, Resource and Project)

Thanks