Custom Enterprise Field

[Girija]

Hello,

I am using MSP 2003. I want to count the total number of tasks in a project,
so I have used Custom Enterprise Field at Task level with the following
formula

IIf([Summary]=No And [External Task]=No,1,0)

It is working fine. But the same when I did with Custom Enterprise Field at
PROJECT level. It didnt work. Can anyone tell as why it didnt work. Is it by
any way linked to Non availability of Summary and External Link fields?

Thanks

Girija

 

[Dale Howard [MVP]]

Girija --

A custom enterprise Project field with a formula considers only the data
contained in the Project Summary Task (Row 0). It does not factor in values
from all subtasks below it. That is why a custom enterprise Task field with
the formula, with the Rollup set to Sum, works correctly. Hope this helps.

 

[Girija]

Thanks a lot Dale.

Girija

Girija --

A custom enterprise Project field with a formula considers only the data
contained in the Project Summary Task (Row 0). It does not factor in values
from all subtasks below it. That is why a custom enterprise Task field with
the formula, with the Rollup set to Sum, works correctly. Hope this helps.

Hello,

I am using MSP 2003. I want to count the total number of tasks in a
project,
so I have used Custom Enterprise Field at Task level with the following
formula

IIf([Summary]=No And [External Task]=No,1,0)

It is working fine. But the same when I did with Custom Enterprise Field
at
PROJECT level. It didnt work. Can anyone tell as why it didnt work. Is it
by
any way linked to Non availability of Summary and External Link fields?

Thanks

Girija

 

[Girija]

Dale

But custom enterprise Task fields cannt be included in the view right? If
so,can you help in understanding in what scenario can we use custom
enterprise Task field !

Thanks

Girija

Girija --

A custom enterprise Project field with a formula considers only the data
contained in the Project Summary Task (Row 0). It does not factor in values
from all subtasks below it. That is why a custom enterprise Task field with
the formula, with the Rollup set to Sum, works correctly. Hope this helps.

Hello,

I am using MSP 2003. I want to count the total number of tasks in a
project,
so I have used Custom Enterprise Field at Task level with the following
formula

IIf([Summary]=No And [External Task]=No,1,0)

It is working fine. But the same when I did with Custom Enterprise Field
at
PROJECT level. It didnt work. Can anyone tell as why it didnt work. Is it
by
any way linked to Non availability of Summary and External Link fields?

Thanks

Girija

 

[Dale Howard [MVP]]

Girija --

If you want to use the task count custom enterprise field, you can use it in
a custom View in Project Professional 2007 or a custom Task Details view in
PWA, but you cannot use it in a Project Center view in PWA. If you want to
see the task count for every project in your Project Server 2007 database,
why don't you create a custom Data Analysis view for this purpose instead?
Create the Data Analysis view using the Tasks Non Timephased cube, add the
Project List dimension to the Row Fields drop area, and add the Task Count
total field to the Total Fields drop area. Just a thought. Hope this
helps.

Dale

But custom enterprise Task fields cannt be included in the view right? If
so,can you help in understanding in what scenario can we use custom
enterprise Task field !

Thanks

Girija

Girija --

A custom enterprise Project field with a formula considers only the data
contained in the Project Summary Task (Row 0). It does not factor in
values
from all subtasks below it. That is why a custom enterprise Task field
with
the formula, with the Rollup set to Sum, works correctly. Hope this
helps.

Hello,

I am using MSP 2003. I want to count the total number of tasks in a
project,
so I have used Custom Enterprise Field at Task level with the following
formula

IIf([Summary]=No And [External Task]=No,1,0)

It is working fine. But the same when I did with Custom Enterprise
Field
at
PROJECT level. It didnt work. Can anyone tell as why it didnt work. Is
it
by
any way linked to Non availability of Summary and External Link fields?

Thanks

Girija

 

[Girija]

Thanks Dale

Girija

Girija --

If you want to use the task count custom enterprise field, you can use it in
a custom View in Project Professional 2007 or a custom Task Details view in
PWA, but you cannot use it in a Project Center view in PWA. If you want to
see the task count for every project in your Project Server 2007 database,
why don't you create a custom Data Analysis view for this purpose instead?
Create the Data Analysis view using the Tasks Non Timephased cube, add the
Project List dimension to the Row Fields drop area, and add the Task Count
total field to the Total Fields drop area. Just a thought. Hope this
helps.

Dale

But custom enterprise Task fields cannt be included in the view right? If
so,can you help in understanding in what scenario can we use custom
enterprise Task field !

Thanks

Girija

Girija --

A custom enterprise Project field with a formula considers only the data
contained in the Project Summary Task (Row 0). It does not factor in
values
from all subtasks below it. That is why a custom enterprise Task field
with
the formula, with the Rollup set to Sum, works correctly. Hope this
helps.




Hello,

I am using MSP 2003. I want to count the total number of tasks in a
project,
so I have used Custom Enterprise Field at Task level with the following
formula

IIf([Summary]=No And [External Task]=No,1,0)

It is working fine. But the same when I did with Custom Enterprise
Field
at
PROJECT level. It didnt work. Can anyone tell as why it didnt work. Is
it
by
any way linked to Non availability of Summary and External Link fields?

Thanks

Girija