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
 
Top