Custom Field Formula Design Question

[Darrell]

All,

In my schedules I have generic resources with the prefix "zz". Project
Managers and Resource Managers are supposed to replace these generics with
named resources prior to 6 weeks from the current date so that from the
current date out 6 weeks we have only named resources. One of the metrics we
are using to review schedule maintenance is the number of generic work hours
within this 6 week window.

So, my question is can I use a custom field to write a formula to copy the
work totals to a number field (done) AND roll up the numbers for just the
tasks with a resources containing the prefix "zz" to the summary tasks using
the same formula?

Darrell

 

[Darrell]

Ok… I placed all generics into the “Group†“Gen†and then used a Flag field
to identify all resources in the “Gen†Group. I then used a function
statement to copy the work field to a Number field based on whether or not
the Flag field was true and whether or not the Start Date was less than
Now()+45, and rolled up the hours to the summary task and it works. The
Number field copies the work field for all generics within the required time
window and shows the total number of generic hours remaining in the next 6
weeks.

Is there a way to make the value that appears in the number field display
with the hrs suffix? Possibly a conversion function?

Darrell

 

[Dave]

Number fields contain numbers. You could use one of the text fields and
simply add the suffix if you wanted.