Hi Julie,
thanks much, this is shown now in the actual assignment by
"roll down".
However, in my summary row, it's not displayed even when I
checked the radio
button "use formula".
Is this because I use the customized "group by" to have number
fields summed
up on resource level (first by group, then by name, with
checkbox "group
assignments")?
When I try it without the customized "group by", I don't see
the sums on
resource level any longer.
So, do I have to choose if I want to see either the sum of my
"actuals" on
resource level and total "work" per group summed up or
alternatively the
total "remaining work" number field on resource level or is
there a way to
have both?
Sorry to bother you so much with this...
Thanks again for your help,
best regards
Gabi
:
Hi Gabi,
As Mike noted, the Work field shows data in minutes. So
assuming
your calendar is set to 8 hours per day -- the 480 you are
seeing is
the number of working minutes for the selected resource. To
convert
to days, just divide the work value by 480. Better, yet,
your
formula could be
[Work]/[Minutes per day]
to give you a value equivalent to work in days. If the
values you
are capturing in your Number field is actual work per day,
make sure
you are using the same conversion factor.
For example, your Number5 field is showing actual work in
days.
Your formula should be:
([Work]/[Minutes per day])- [Number5]
I hope this helps.
Julie
Hi Julie,
ok, understand.
When I just show it on the resource row, I have weird
values in
there, also
if I only have the formula [work] in there, it will display
e.g.
480 instead
the work value which is 1 day (and corresponding values for
bigger
work
items).... also, when I try to execute a multiplication or
so, it
will not
change at all.
Do you have an idea what it shows me?
Thanks much for your help again and for your patience
BR
Gabi
:
Hi Gabi,
Unfortunately, formulas you write in the Resource usage
view only
apply to resources, not assignments, so your formula will
not
calculate for assignment rows.
However, you should still see the value at the resource
row.
Your
formula shouldn't start with an equals (=) sign -- it
should just
be:
[Number5]
in the formula box.
To calculate your values for the assignment rows, you'll
need
some
VBA code. I'm not the best resource on that at all. If
you'd
like
some assistance with that, post a new question to the
project
developer newsgroup with the specific details of what you
have
and
what you'd like to calculate. One of the VBA gurus may
give you
guidance get going in the right direction.
Julie
Hi Julie,
I have tried to figure out how the copy macro could help
me,
but I
think I
have a different situation in my plan:
In my resource view, I have a number-field wich contains
visible
values on
the level of the task assigned to the resource, so I
think it's
already an
assignment field?
As an example, I have added a value in the original
"actual
work"
column in
the resource form view area, and it will be displayed
next to
my
number field
with the other value.
So, I think it's not required to copy the data into the
assignment
field as
in the text example of the macro, is that correct?
So, what I don't understand at all is why an additional
number-field will
not show me the same number as the filled one when I
have the
formula only
"=[number5].
This is really hard to explain without the example, I
hope you
know what I
mean?
Thanks much again and best regards
Gabi
:
You're welcome Gabi. Let us know how you get along.
Best,
Julie
message
Hi Julie,
thanks much for the hint - I didn't even know about
the
difference
between
resource field and assignment field in the usage
view... :-/
Unfortunately, I can't use the already available
"remaining
work"
as my
company template fills our actuals into a custom
number
field
in
the task
view which I copy by macro into my "own" resource
number
field.
I have tried to use the "roll down" function (which
only
worked
when I
de-activated the formula radio button) but this will
show me
interesting
numbers where I have no clue where they come from
It
does
not
seem to be
related to the [work] in my formula.
But as I use a grouping/summing filter, it will
beautifully
add
up
on the
resource summary level....
But I'll try to see what happens when I use the copy
macro
you
suggest in
your answer.
I'll let you know if you made my day again
CU and thanks,
Gabi
:
Hello Gabi,
When you add a formula to a custom field in either
the
Resource
Usage or Task Usage views, the formula will
calculate only
for
the
resources in the Resource Usage view or the tasks in
the
Task
Usage
view -- not the assignment. So, your Number6 field
should
show a
value for the resource rows assuming you have work
assigned
to
the
resources, but should show zero for the assignment
rows.
You can choose the option for assignment rows of
"Roll down
unless
manually entered" but this will simply duplicate the
resource
row
value to the assignment row.
See FAQs 37 & 51 at
http://project.mvps.org/faqs.htm
for
some
additional information including a macro to copy
data.
Have you considered using the Remaining Work field
in the
Resource
usage view? It automatically calculates remaining
work for
resources and assignments based upon baseline work
and
actuals.
I hope this helps. Let us know how you get along.
Julie
Project MVP
Visit
http://project.mvps.org/ for the FAQs and
additional
information about Microsoft Project
message
Dear all,
I need some help, please....
I have added the column "number 6" in the resource
usage
view
and
want to
use a formula to calculate remaining budget from
the
columns
"work" and
"number5" where I store my actuals.
I have used the "customize fields" window to enter
a
formula:
[Work] -
[Number5].
However, whatever formula I enter, nothing is
displayed
in
the
field.
E.g. trying only to show the content of my
"number5" even
did
not
work out,
let alone a calculation of "work - number5".
Is there any trick in calculating formulas in the
resource
view?
I'm using MSP 2007.
Thanks much in advance for your help,
best regards
Gabi
