Counting occurances inside Project?

[LJI]

I have a series of projects that contain Custom Column Views whereby a color
coded bubble is displayed depending on the results of a simple formula.

These bubbles represent a graphical indication of the status of a given task
relative to the saved baseline.
RED = >2wks variance GREEN <= 2wks WHITE = NO Baseline

My question is: Is is possible for Project to COUNT the number of RED vs.
GREEN bubbles and return a value? My overall goal is to determine the
PERCENTAGE of tasks that are either On Schedule or Late by some critieria.

thx

 

[Rod Gill]

Hi,

I think you will either need to do this manually or use a VBA macro. I
thought of using Groups, but Groups don't appear to offer a choice of COUNT.

 

[LJI]

Thanks Rod. I kinda figured it out. I had to 'brute force it'.

I exported the file to excel, then wrote a formula to count
the occurances of the Text that each of the bubbles were mapped to.

Multi-Step approach, but seems to work for now. It sure would be great
if there was a way to write a report inside Project.

LJI

 

[Mike Glen]

Hi LJI,

Try inserting a Number1 column and customizing it in the same way you did
for your graphic indicators. For example: IIf([Start Variance]>14,1,0) and
insure Rollup is set to Sum, you will get a series of ones when the
condition is met, and the sum is rolled up to the summary. This should get
you started to get what you seem to want.


FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[tonyzink]

Hi LJI --

I was going to suggest something similar to Mike's solution... he beat
me to it!

If you're going to count the Greens, Yellows, & Reds, then you may also
want to think about whether or not you want to ignore certain types of
tasks... such as summary tasks. Is it important for you to count all
line items, or just tasks & milestones? If you'd like to ignore
summaries, for instance, you can integrate another "IIf" condition into
your formula.

Good luck!

Tony Zink
========================================
http://www.msprojectreporter.com
http://www.pmreporter.com
http://www.sharepointreporter.com
http://www.msofficereporter.com
http://www.dotnetreporter.com
========================================