Re: Formula problem in resource usage number field

Hi Julie,
I have Project 2007, but I don't see info about an SP.

This is my formula: [Work]/480-[Number5]

I have the following settings now:
calculation for task+group summary rows: none
calculation for assignment rows: none
no customized group
--> then, I get the following displayed:
sums on resource level (nicely in daily format :-), minutes are gone now for
some reason), no value on assignment level (sorry, I mistyped here in my last
response)
-->> the problem with this is: I don't have a grouping now which means that
I can't show the "work" per group and don't have any totals at all, only on
resource level.

When I use my customized group now (with same settings as above), I get the
following displayed:
--> no value on either resource level or assignment level

Then, I changed the "customize field" settings to
calculation for task+group summary rows: use formula
--> now, it calculates the difference on group level (resource sum and group
sum)

This is weird because yesterday, it was not possible to show the
calculations... maybe it's important in which sequence I make the settings....

So, I think I finally managed to get what I wanted to see --> I need to save
this version!! :-))

Just the formula result on assignment level is missing but you mentioned
this is not possible without a macro.

Thanks VERY much for your help! I appreciate it a lot!
BR
Gabi


"JulieS" wrote:

Hi Gabi,

Hmmm. That is odd. Let's just take a step back here -- you are using
Project 2007 -- do you have service pack 1 applied to project?

What specific formula are you using? Copy and paste to your reply.

I am understanding you to say that in your Resource Usage view, you have
entered the formula and don't see any values for the Resource row but you see
values for the assignment row? Even if you do not group?

Don't apologize for being a "bother" that's why these newsgroups are here --
it's never a bother :-)

Julie

"Gabi" wrote:

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


"JulieS" wrote:

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

"Gabi" <Gabi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:942EBE4F-7069-4DBE-B8F9-46C201E68012@xxxxxxxxxxxxxxxx
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

"JulieS" wrote:

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
"Gabi" <Gabi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF59E3E4-7A91-4331-A3D6-471555CB6A3B@xxxxxxxxxxxxxxxx
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

"JulieS" wrote:

You're welcome Gabi. Let us know how you get along.

Best,
Julie

"Gabi" <Gabi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:19A595F3-ACC8-464F-B15D-D5EBAF154FA4@xxxxxxxxxxxxxxxx
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

"JulieS" wrote:

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

"Gabi" <Gabi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2D2C19AD-4AB0-45C5-A227-E350EF81E1C0@xxxxxxxxxxxxxxxx
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












.