Jim Sipe said:
Dale Howard said:
Let usJim Sipe said:
Dale Howard said:Jim --
You used the correct formula: [Duration2]
I have not had time to test this myself, so perhaps it is not possible to
use an enterprise field to calculate a value from a local field. It SHOULD
work, but then again, stranger things have been known to happen.
know if it works at all.
Jim Sipe said:
Jim Sipe said:Just entering [Duration2] in the formula box keeps giving me a syntax
error.
Dale Howard said:Jim --
You used the correct formula: [Duration2]
I have not had time to test this myself, so perhaps it is not possible to
use an enterprise field to calculate a value from a local field. It
SHOULD
work, but then again, stranger things have been known to happen.
us
know if it works at all.
Jim Sipe said:
Gary L. Chefetz said:Jim:
You can't reference local custom fields for formulas in Enterprise custom
fields, you can, however reference built-in fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Jim Sipe said:Just entering [Duration2] in the formula box keeps giving me a syntax
error.
Dale Howard said:Jim --
You used the correct formula: [Duration2]
I have not had time to test this myself, so perhaps it is not possible to
use an enterprise field to calculate a value from a local field. It
SHOULD
work, but then again, stranger things have been known to happen.
us
know if it works at all.
I did use duration in one of my attempts, but I may have had the formula
incorrect. What do I enter in the formula box?
:
Jim --
For the Duration1, Duration2, and Duration3 fields, you need to use a
custom
Duration field. Did you do so? For the Start1, Start2, Start3,
Finish1,
Finish2, and Finish3 fields, you need to use a Date field. Did you do
so?
And you should definitely use the Task type, as this is task data on
which
you are reporting. Let us know.
Follow on question Dale:
I am not getting this to work; In generating the custom field, I
used
an
Entity" of "Task", tried different Types (which should I use), and
can't
get
the formula to work. I just entered [Duration2] in the formula box
and
keep
getting a syntax error.
Thanks in advance for your help.
:
Perfect, I'll try your recommendation; thanks for the quick
response.
:
Jim --
The fields that PERT Analysis uses are local Task field. For
example,
in
the PA_Optimistic Case table, the Optimistic Duration field is
actually
the
Duration1 field with the Title information changed to show Opt
Dur
in
the
column header. The Optimistic Start field is actually the Start1
field,
again, with the Title information changed to show Opt Start in
the
column
header. The Optimistic Finish field is actually the Finish1
field,
again,
with the Title information changed to show Opt Finish in the
column
header.
In the PA_Expected Case table, the system uses the Duration2,
Start2,
and
Finish2 fields, with their Titles changed to reflect the column
names
you
see. In the PA_Pessimistic Case table, the system uses the
Duration3,
Start3, and Finish3 fields, with their Titles changed to reflect
the
column
names you see.
This being said, you can certainly use the local Duration1,
Start1,
Finish1,
Duration2, Start2, Finish2, Duration3, Start3, and Finish3 fields
in
a
detailed Project view in PWA, but you will run into two issues:
1. You cannot specify a Title on columns in PWA the way you can
do
in
Project Professional. This means you would have to memorize the
fact
that
the Duration1 field is actually the Optimistic Duration field.
2. Oddly enough, I built a custom detailed Project view in PWA
containing
the above fields. Then I created an enterprise project, used the
PERT
Analysis tool to generate Duration values, saved and published
the
project.
In my custom detailed Project view in PWA for that sample
project, I
can see
all of the columns I added (Duration1, Start1, Finish1, etc.),
but I
cannot
see Duration values in the Duration1, Duration2, and Duration3
fields.
I
can only assume this is a bug.
Given the two limitations above, I think a better way to address
this
would
be to create custom enterprise Duration and Date fields for this
purpose.
You would probably need to use a formula in those fields to
capture
the
data
from the local fields to which they correspond. Or you could
write
a
macro
that automatically performs the PERT Analysis and enters the
values
in
the
enterprise fields for you instead of the local fields. Just some
thought.
Hope this helps.
Running Project Server 2007 with SP1.
Are the PERT Analysis fields available for creating a custom
view
on
PWA?
I
am notable to locate them. I would like to extend a PERT
Analysis
into
PWA
for viewing purposes.
Jim Sipe said:I just want to be able to create a View in PWA that will show the fields
associated with a PERT Analysis. Dale indicated that this should be done
using a formula. As an example, the values from a published schedule that
has values in Duration2 is not being shown in a custom view in PWA. Is
there
another solution to solve this issue?
Thanks in advance.
Gary L. Chefetz said:Jim:
You can't reference local custom fields for formulas in Enterprise custom
fields, you can, however reference built-in fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Jim Sipe said:Just entering [Duration2] in the formula box keeps giving me a syntax
error.
:
Jim --
You used the correct formula: [Duration2]
I have not had time to test this myself, so perhaps it is not possible
to
use an enterprise field to calculate a value from a local field. It
SHOULD
work, but then again, stranger things have been known to happen.
Let
us
know if it works at all.
I did use duration in one of my attempts, but I may have had the
formula
incorrect. What do I enter in the formula box?
:
Jim --
For the Duration1, Duration2, and Duration3 fields, you need to use
a
custom
Duration field. Did you do so? For the Start1, Start2, Start3,
Finish1,
Finish2, and Finish3 fields, you need to use a Date field. Did you
do
so?
And you should definitely use the Task type, as this is task data
on
which
you are reporting. Let us know.
Follow on question Dale:
I am not getting this to work; In generating the custom field, I
used
an
Entity" of "Task", tried different Types (which should I use),
and
can't
get
the formula to work. I just entered [Duration2] in the formula
box
and
keep
getting a syntax error.
Thanks in advance for your help.
:
Perfect, I'll try your recommendation; thanks for the quick
response.
:
Jim --
The fields that PERT Analysis uses are local Task field. For
example,
in
the PA_Optimistic Case table, the Optimistic Duration field is
actually
the
Duration1 field with the Title information changed to show Opt
Dur
in
the
column header. The Optimistic Start field is actually the
Start1
field,
again, with the Title information changed to show Opt Start in
the
column
header. The Optimistic Finish field is actually the Finish1
field,
again,
with the Title information changed to show Opt Finish in the
column
header.
In the PA_Expected Case table, the system uses the Duration2,
Start2,
and
Finish2 fields, with their Titles changed to reflect the
column
names
you
see. In the PA_Pessimistic Case table, the system uses the
Duration3,
Start3, and Finish3 fields, with their Titles changed to
reflect
the
column
names you see.
This being said, you can certainly use the local Duration1,
Start1,
Finish1,
Duration2, Start2, Finish2, Duration3, Start3, and Finish3
fields
in
a
detailed Project view in PWA, but you will run into two
issues:
1. You cannot specify a Title on columns in PWA the way you
can
do
in
Project Professional. This means you would have to memorize
the
fact
that
the Duration1 field is actually the Optimistic Duration field.
2. Oddly enough, I built a custom detailed Project view in
PWA
containing
the above fields. Then I created an enterprise project, used
the
PERT
Analysis tool to generate Duration values, saved and published
the
project.
In my custom detailed Project view in PWA for that sample
project, I
can see
all of the columns I added (Duration1, Start1, Finish1, etc.),
but I
cannot
see Duration values in the Duration1, Duration2, and Duration3
fields.
I
can only assume this is a bug.
Given the two limitations above, I think a better way to
address
this
would
be to create custom enterprise Duration and Date fields for
this
purpose.
You would probably need to use a formula in those fields to
capture
the
data
from the local fields to which they correspond. Or you could
write
a
macro
that automatically performs the PERT Analysis and enters the
values
in
the
enterprise fields for you instead of the local fields. Just
some
thought.
Hope this helps.
message
Running Project Server 2007 with SP1.
Are the PERT Analysis fields available for creating a custom
view
on
PWA?
I
am notable to locate them. I would like to extend a PERT
Analysis
into
PWA
for viewing purposes.
Gary L. Chefetz said:Jim:
Two options come to mind: 1) Use a macro to populate the PERT data into
custom Enterprise Fields, or 2) recreate the PERT calcs using Enterprise
fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Jim Sipe said:I just want to be able to create a View in PWA that will show the fields
associated with a PERT Analysis. Dale indicated that this should be done
using a formula. As an example, the values from a published schedule that
has values in Duration2 is not being shown in a custom view in PWA. Is
there
another solution to solve this issue?
Thanks in advance.
Gary L. Chefetz said:Jim:
You can't reference local custom fields for formulas in Enterprise custom
fields, you can, however reference built-in fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Just entering [Duration2] in the formula box keeps giving me a syntax
error.
:
Jim --
You used the correct formula: [Duration2]
I have not had time to test this myself, so perhaps it is not possible
to
use an enterprise field to calculate a value from a local field. It
SHOULD
work, but then again, stranger things have been known to happen.
Let
us
know if it works at all.
I did use duration in one of my attempts, but I may have had the
formula
incorrect. What do I enter in the formula box?
:
Jim --
For the Duration1, Duration2, and Duration3 fields, you need to use
a
custom
Duration field. Did you do so? For the Start1, Start2, Start3,
Finish1,
Finish2, and Finish3 fields, you need to use a Date field. Did you
do
so?
And you should definitely use the Task type, as this is task data
on
which
you are reporting. Let us know.
Follow on question Dale:
I am not getting this to work; In generating the custom field, I
used
an
Entity" of "Task", tried different Types (which should I use),
and
can't
get
the formula to work. I just entered [Duration2] in the formula
box
and
keep
getting a syntax error.
Thanks in advance for your help.
:
Perfect, I'll try your recommendation; thanks for the quick
response.
:
Jim --
The fields that PERT Analysis uses are local Task field. For
example,
in
the PA_Optimistic Case table, the Optimistic Duration field is
actually
the
Duration1 field with the Title information changed to show Opt
Dur
in
the
column header. The Optimistic Start field is actually the
Start1
field,
again, with the Title information changed to show Opt Start in
the
column
header. The Optimistic Finish field is actually the Finish1
field,
again,
with the Title information changed to show Opt Finish in the
column
header.
In the PA_Expected Case table, the system uses the Duration2,
Start2,
and
Finish2 fields, with their Titles changed to reflect the
column
names
you
see. In the PA_Pessimistic Case table, the system uses the
Duration3,
Start3, and Finish3 fields, with their Titles changed to
reflect
the
column
names you see.
This being said, you can certainly use the local Duration1,
Start1,
Finish1,
Duration2, Start2, Finish2, Duration3, Start3, and Finish3
fields
in
a
detailed Project view in PWA, but you will run into two
issues:
1. You cannot specify a Title on columns in PWA the way you
can
do
in
Project Professional. This means you would have to memorize
the
fact
that
the Duration1 field is actually the Optimistic Duration field.
2. Oddly enough, I built a custom detailed Project view in
PWA
containing
the above fields. Then I created an enterprise project, used
the
PERT
Analysis tool to generate Duration values, saved and published
the
project.
In my custom detailed Project view in PWA for that sample
project, I
can see
all of the columns I added (Duration1, Start1, Finish1, etc.),
but I
cannot
see Duration values in the Duration1, Duration2, and Duration3
fields.
I
can only assume this is a bug.
Given the two limitations above, I think a better way to
address
this
would
be to create custom enterprise Duration and Date fields for
this
purpose.
You would probably need to use a formula in those fields to
capture
the
data
from the local fields to which they correspond. Or you could
write
a
macro
that automatically performs the PERT Analysis and enters the
values
in
the
enterprise fields for you instead of the local fields. Just
some
thought.
Hope this helps.
message
Running Project Server 2007 with SP1.
Are the PERT Analysis fields available for creating a custom
view
on
PWA?
I
am notable to locate them. I would like to extend a PERT
Analysis
into
PWA
for viewing purposes.
Jim Sipe said:Start/Finish 1, 2,and 3 are available for a custom view in PWA, but not
Duration 1, 2, & 3. I may be satisified just using the Start/Finish
fields.
Just in case; however, how would I go about implementing your Option 2? I
created Enterprise Custom Fields for the three Duration entries, but am
not
sure how to integrate them into the Microsoft formula that does the
calculations.
Sorry for being so dense, but thanks for the great assistance.
Gary L. Chefetz said:Jim:
Two options come to mind: 1) Use a macro to populate the PERT data into
custom Enterprise Fields, or 2) recreate the PERT calcs using Enterprise
fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Jim Sipe said:I just want to be able to create a View in PWA that will show the fields
associated with a PERT Analysis. Dale indicated that this should be
done
using a formula. As an example, the values from a published schedule
that
has values in Duration2 is not being shown in a custom view in PWA. Is
there
another solution to solve this issue?
Thanks in advance.
:
Jim:
You can't reference local custom fields for formulas in Enterprise
custom
fields, you can, however reference built-in fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Just entering [Duration2] in the formula box keeps giving me a
syntax
error.
:
Jim --
You used the correct formula: [Duration2]
I have not had time to test this myself, so perhaps it is not
possible
to
use an enterprise field to calculate a value from a local field.
It
SHOULD
work, but then again, stranger things have been known to happen.
Let
us
know if it works at all.
I did use duration in one of my attempts, but I may have had the
formula
incorrect. What do I enter in the formula box?
:
Jim --
For the Duration1, Duration2, and Duration3 fields, you need to
use
a
custom
Duration field. Did you do so? For the Start1, Start2, Start3,
Finish1,
Finish2, and Finish3 fields, you need to use a Date field. Did
you
do
so?
And you should definitely use the Task type, as this is task
data
on
which
you are reporting. Let us know.
Follow on question Dale:
I am not getting this to work; In generating the custom field,
I
used
an
Entity" of "Task", tried different Types (which should I use),
and
can't
get
the formula to work. I just entered [Duration2] in the
formula
box
and
keep
getting a syntax error.
Thanks in advance for your help.
:
Perfect, I'll try your recommendation; thanks for the quick
response.
:
Jim --
The fields that PERT Analysis uses are local Task field.
For
example,
in
the PA_Optimistic Case table, the Optimistic Duration field
is
actually
the
Duration1 field with the Title information changed to show
Opt
Dur
in
the
column header. The Optimistic Start field is actually the
Start1
field,
again, with the Title information changed to show Opt Start
in
the
column
header. The Optimistic Finish field is actually the
Finish1
field,
again,
with the Title information changed to show Opt Finish in
the
column
header.
In the PA_Expected Case table, the system uses the
Duration2,
Start2,
and
Finish2 fields, with their Titles changed to reflect the
column
names
you
see. In the PA_Pessimistic Case table, the system uses the
Duration3,
Start3, and Finish3 fields, with their Titles changed to
reflect
the
column
names you see.
This being said, you can certainly use the local Duration1,
Start1,
Finish1,
Duration2, Start2, Finish2, Duration3, Start3, and Finish3
fields
in
a
detailed Project view in PWA, but you will run into two
issues:
1. You cannot specify a Title on columns in PWA the way
you
can
do
in
Project Professional. This means you would have to
memorize
the
fact
that
the Duration1 field is actually the Optimistic Duration
field.
2. Oddly enough, I built a custom detailed Project view in
PWA
containing
the above fields. Then I created an enterprise project,
used
the
PERT
Analysis tool to generate Duration values, saved and
published
the
project.
In my custom detailed Project view in PWA for that sample
project, I
can see
all of the columns I added (Duration1, Start1, Finish1,
etc.),
but I
cannot
see Duration values in the Duration1, Duration2, and
Duration3
fields.
I
can only assume this is a bug.
Given the two limitations above, I think a better way to
address
this
would
be to create custom enterprise Duration and Date fields for
this
purpose.
You would probably need to use a formula in those fields to
capture
the
data
from the local fields to which they correspond. Or you
could
write
a
macro
that automatically performs the PERT Analysis and enters
the
values
in
the
enterprise fields for you instead of the local fields.
Just
some
thought.
Hope this helps.
message
Running Project Server 2007 with SP1.
Are the PERT Analysis fields available for creating a
custom
view
on
PWA?
I
am notable to locate them. I would like to extend a PERT
Analysis
into
PWA
for viewing purposes.
Gary L. Chefetz said:Jim:
The formula is for the PERT calculation simply applies a weighting. Off the
top of my head (I would need to check one of my books that I don't have on
hand here on the road for the exact weighting) it's something like
((expected duration x 2) + pessimistic + optimistic) / 4
If my brain were functioning better at the moment I'd remember, but it could
be 4 x Expected duration and divide by 6.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Jim Sipe said:Start/Finish 1, 2,and 3 are available for a custom view in PWA, but not
Duration 1, 2, & 3. I may be satisified just using the Start/Finish
fields.
Just in case; however, how would I go about implementing your Option 2? I
created Enterprise Custom Fields for the three Duration entries, but am
not
sure how to integrate them into the Microsoft formula that does the
calculations.
Sorry for being so dense, but thanks for the great assistance.
Gary L. Chefetz said:Jim:
Two options come to mind: 1) Use a macro to populate the PERT data into
custom Enterprise Fields, or 2) recreate the PERT calcs using Enterprise
fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
I just want to be able to create a View in PWA that will show the fields
associated with a PERT Analysis. Dale indicated that this should be
done
using a formula. As an example, the values from a published schedule
that
has values in Duration2 is not being shown in a custom view in PWA. Is
there
another solution to solve this issue?
Thanks in advance.
:
Jim:
You can't reference local custom fields for formulas in Enterprise
custom
fields, you can, however reference built-in fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Just entering [Duration2] in the formula box keeps giving me a
syntax
error.
:
Jim --
You used the correct formula: [Duration2]
I have not had time to test this myself, so perhaps it is not
possible
to
use an enterprise field to calculate a value from a local field.
It
SHOULD
work, but then again, stranger things have been known to happen.
Let
us
know if it works at all.
I did use duration in one of my attempts, but I may have had the
formula
incorrect. What do I enter in the formula box?
:
Jim --
For the Duration1, Duration2, and Duration3 fields, you need to
use
a
custom
Duration field. Did you do so? For the Start1, Start2, Start3,
Finish1,
Finish2, and Finish3 fields, you need to use a Date field. Did
you
do
so?
And you should definitely use the Task type, as this is task
data
on
which
you are reporting. Let us know.
Follow on question Dale:
I am not getting this to work; In generating the custom field,
I
used
an
Entity" of "Task", tried different Types (which should I use),
and
can't
get
the formula to work. I just entered [Duration2] in the
formula
box
and
keep
getting a syntax error.
Thanks in advance for your help.
:
Perfect, I'll try your recommendation; thanks for the quick
response.
:
Jim --
The fields that PERT Analysis uses are local Task field.
For
example,
in
the PA_Optimistic Case table, the Optimistic Duration field
is
actually
the
Duration1 field with the Title information changed to show
Opt
Dur
in
the
column header. The Optimistic Start field is actually the
Start1
field,
again, with the Title information changed to show Opt Start
in
the
column
header. The Optimistic Finish field is actually the
Finish1
field,
again,
with the Title information changed to show Opt Finish in
the
column
header.
In the PA_Expected Case table, the system uses the
Duration2,
Start2,
and
Finish2 fields, with their Titles changed to reflect the
column
names
you
see. In the PA_Pessimistic Case table, the system uses the
Duration3,
Start3, and Finish3 fields, with their Titles changed to
reflect
the
column
names you see.
This being said, you can certainly use the local Duration1,
Start1,
Finish1,
Duration2, Start2, Finish2, Duration3, Start3, and Finish3
fields
in
a
detailed Project view in PWA, but you will run into two
issues:
1. You cannot specify a Title on columns in PWA the way
you
can
do
in
Project Professional. This means you would have to
memorize
the
fact
that
the Duration1 field is actually the Optimistic Duration
field.
2. Oddly enough, I built a custom detailed Project view in
PWA
containing
the above fields. Then I created an enterprise project,
used
the
PERT
Analysis tool to generate Duration values, saved and
published
the
project.
In my custom detailed Project view in PWA for that sample
project, I
can see
all of the columns I added (Duration1, Start1, Finish1,
etc.),
but I
cannot
see Duration values in the Duration1, Duration2, and
Duration3
fields.
I
can only assume this is a bug.
Given the two limitations above, I think a better way to
address
this
would
be to create custom enterprise Duration and Date fields for
this
purpose.
You would probably need to use a formula in those fields to
capture
the
data
from the local fields to which they correspond. Or you
could
write
a
macro
that automatically performs the PERT Analysis and enters
the
values
in
the
enterprise fields for you instead of the local fields.
Just
some
thought.
Hope this helps.
--
Jim Sipe said:The Duration value created by that formula is already being recorded and
displayed in the Duration field. What I am trying to do, is create a View
in
PWA that will show the PERT Analysis populated Duration1, Duration2, and
Duration3. These fields are always empty in a PWA View. Earlier in this
thread, Dale indicated there may be a "bug". I am beginning to believe
that.
Thanks for all of your help on this.
Gary L. Chefetz said:Jim:
The formula is for the PERT calculation simply applies a weighting. Off
the
top of my head (I would need to check one of my books that I don't have
on
hand here on the road for the exact weighting) it's something like
((expected duration x 2) + pessimistic + optimistic) / 4
If my brain were functioning better at the moment I'd remember, but it
could
be 4 x Expected duration and divide by 6.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Jim Sipe said:Start/Finish 1, 2,and 3 are available for a custom view in PWA, but not
Duration 1, 2, & 3. I may be satisified just using the Start/Finish
fields.
Just in case; however, how would I go about implementing your Option 2?
I
created Enterprise Custom Fields for the three Duration entries, but am
not
sure how to integrate them into the Microsoft formula that does the
calculations.
Sorry for being so dense, but thanks for the great assistance.
:
Jim:
Two options come to mind: 1) Use a macro to populate the PERT data
into
custom Enterprise Fields, or 2) recreate the PERT calcs using
Enterprise
fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
I just want to be able to create a View in PWA that will show the
fields
associated with a PERT Analysis. Dale indicated that this should be
done
using a formula. As an example, the values from a published
schedule
that
has values in Duration2 is not being shown in a custom view in PWA.
Is
there
another solution to solve this issue?
Thanks in advance.
:
Jim:
You can't reference local custom fields for formulas in Enterprise
custom
fields, you can, however reference built-in fields.
--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
Just entering [Duration2] in the formula box keeps giving me a
syntax
error.
:
Jim --
You used the correct formula: [Duration2]
I have not had time to test this myself, so perhaps it is not
possible
to
use an enterprise field to calculate a value from a local field.
It
SHOULD
work, but then again, stranger things have been known to happen.
Let
us
know if it works at all.
I did use duration in one of my attempts, but I may have had
the
formula
incorrect. What do I enter in the formula box?
:
Jim --
For the Duration1, Duration2, and Duration3 fields, you need
to
use
a
custom
Duration field. Did you do so? For the Start1, Start2,
Start3,
Finish1,
Finish2, and Finish3 fields, you need to use a Date field.
Did
you
do
so?
And you should definitely use the Task type, as this is task
data
on
which
you are reporting. Let us know.
message
Follow on question Dale:
I am not getting this to work; In generating the custom
field,
I
used
an
Entity" of "Task", tried different Types (which should I
use),
and
can't
get
the formula to work. I just entered [Duration2] in the
formula
box
and
keep
getting a syntax error.
Thanks in advance for your help.
:
Perfect, I'll try your recommendation; thanks for the
quick
response.
:
Jim --
The fields that PERT Analysis uses are local Task field.
For
example,
in
the PA_Optimistic Case table, the Optimistic Duration
field
is
actually
the
Duration1 field with the Title information changed to
show
Opt
Dur
in
the
column header. The Optimistic Start field is actually
the
Start1
field,
again, with the Title information changed to show Opt
Start
in
the
column
header. The Optimistic Finish field is actually the
Finish1
field,
again,
with the Title information changed to show Opt Finish in
the
column
header.
In the PA_Expected Case table, the system uses the
Duration2,
Start2,
and
Finish2 fields, with their Titles changed to reflect the
column
names
you
see. In the PA_Pessimistic Case table, the system uses
the
Duration3,
Start3, and Finish3 fields, with their Titles changed to
reflect
the
column
names you see.
This being said, you can certainly use the local
Duration1,
Start1,
Finish1,
Duration2, Start2, Finish2, Duration3, Start3, and
Finish3
fields
in
a
detailed Project view in PWA, but you will run into two
issues:
1. You cannot specify a Title on columns in PWA the way
you
can
do
in
Project Professional. This means you would have to
memorize
the
fact
that
the Duration1 field is actually the Optimistic Duration
field.
2. Oddly enough, I built a custom detailed Project view
in
PWA
containing
the above fields. Then I created an enterprise project,
used
the
PERT
Analysis tool to generate Duration values, saved and
published
the
project.
In my custom detailed Project view in PWA for that
sample
project, I
can see
all of the columns I added (Duration1, Start1, Finish1,
etc.),
but I
cannot
see Duration values in the Duration1, Duration2, and
Duration3
fields.
I
can only assume this is a bug.
Given the two limitations above, I think a better way to
address
this
would
be to create custom enterprise Duration and Date fields
for
this
purpose.
You would probably need to use a formula in those fields
to
capture
the
data
from the local fields to which they correspond. Or you
could
write
a
macro
that automatically performs the PERT Analysis and enters
the
values
in
the
enterprise fields for you instead of the local fields.
Just
some
thought.
Hope this helps.
--