Using a rollup value in a formula

[Jason]

I am using Project 2003, though I can use 2007 if need be.

I have values in "Cost1" and have the roll-up set to Sum. What I want to do
is use these rollup values and the Rollup of "Cost" in a formula in field
"Number1". Is this possible? Do I need to create an Enterprise Field with
the Sums in it and then use that field in my formula. I am new to the whole
formua concept so I appoligize if this is a bit basic.

Thanks.

 

[Jim Aksel]

Formula results can only be used on the same line where they are calculated
using formulas. That is, if you sum Cost1 up to the summary level, there is
no formula that will allow you to use the summed value of Cost1 ... for
example to determine the % of cost1 for each line compared to the summary
value.

All is not lost. You can use Visual Basic for Applications (VBA) and write
your own Macro that will do that.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Jason]

Jim,

Thank you for the clarification. Now the really stupid question. Where and
how would I write the VBA Macro? I keep reading about these in the posts
here but have never done one and this seems like a good place to start.

Thanks
Jason