Caculated Fields at Summary Level

Joined
Jul 20, 2011
Messages
1
Reaction score
0
Hi

I have a calculated field in MS 2003, which I have set to show at the summary level.

But it does not appear to be assinging the correct value to the summary level, works fine at the task level.

Can anyone help?

Alison
 
Joined
Nov 11, 2011
Messages
6
Reaction score
0
Calculated fields in summary tasks

Hi,
Just a quick thought, but have you made sure you've told the custom field what to do for Summary Rows?
On the Custom Field dialog there's a section labelled "Calculation for task and group summary rows"
You can select None, Rollup, or Use Formula.

None - performs no calculation

Rollup - uses any of the standard aggregate functions to aggregate the data from the subtasks in the group (e.g. SUM, AVERAGE etc)

Use Formula - Use the same calculation for summary tasks as for subtasks.

Try changing these settings until you get the one you want.

You can see a blog about how to do this here:
wiseowl.co.uk/blog/s151/custom_fields_in_microsoft_project_pt1.htm

You can also view a video tutorial here:
youtube.com/watch?v=5fDfNTPKsZU

Hope it helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top