totaling # of resources by type & cost

J

jasminedancer

I'm re-posting because my previous post was so long I figured no one
wanted to plow through it. How can I make a view (either in PWA or
project) that will sum up the number of resources I have by
consultant/employee, and sub-total their respective costs?

thanks.
Naomi
 
M

Mark E. Read

Hi Naomi,

Here is a quick solution: add a resource number or text field called
"count" with a value of one (1) and assign that value to each resource.
Then when you include that field (and your cost fields) in a view, and
use the "group by" functionality, you may get the results you are
looking for.

Let me know if that helps.

--Mark
Mark Read
[email protected]
 
N

Naomi Nissen

Mark, I'm not quite sure how to do this. I know how to do a count
formula in Excel, but that's it. Is this in a PWA view or Project?
Also, what do you mean by "assign that value to each resource? Put the
number 1 in the field for that resource? And how does this give me a
total?

thanks!
 
M

Mark E. Read

Hi Naomi, thanks for the email.

I was thinking this was a Project view, not a PWA view, and yes, puting
a number 1 in the field for that resource is what I was thinking. When
you do a group by, you will get a rollup if the number field is set to
sum. The challenge here is I think you need a count of resources, and
that will be a bit more challenging in a task view. I was thinking
this was a task rollup. There are some tools in 2007 that make this
easier, or it might make sense to build some SQL that does a select
unique, so that you count the resources and not the tasks. Sorry for
the confusion.

--Mark
 
M

Mark E. Read

One more thing, if you are in a resource usage view, then you should be
able to use a resource number field as a rollup.
 
Top