working outline levels project

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Working with outline levels in Project formulas | MS-Project forum

Working with outline levels in Project formulas | MS-Project forum

resolvedResolved · Medium Priority · Version 2007

Edited on Wed 26 Mar 2014, 10:16

Gianluigi has attended:
No courses

Working with outline levels in Project formulas

I’d a question for you about project formulas, if you may kindly address me.

How to write formula with correct syntax for this case:

I have two colums

Baseline Work at Outline Level 3 only
Work at Outline Level 4



I want to show in a third customized field a progress percentage ([Work]/[Baseline Work]*100) showing results at each Outline Level 3, calculated on items at Outline Level 4 belonging to that Outline Level 3.

May you kindly give me any input?

Thanks in advance for this
Gianluigi Goglio
Milan Italy

RE: Working with outline levels in Project formulas

Hi Gianluigi

Thank you for your question. One way that might answer this would be first to create your formula in the customised field. Just below the formula setting in the Custom Fields dialogue box there is an additional option to control how the calculation should behave on summary rows.

You might want to experiment between roll up (which brings the values up from the lower level) or use Formula which applies the formula directly to the higher level summary task.

Let me know if that produces the results you are looking for.

Kind regards,
Andrew

Thu 3 Apr 2014: Automatically marked as resolved.


 

MS Project tip:

Entering Days

To type in a day of the week, or its three letter abbreviation, in a Date field type "Monday" or "Mon", and Project will show the date for the next Monday after the current date.

View all MS Project hints and tips


Server loaded in 0.07 secs.