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

Resolved · Medium Priority · Version 2007

Wed 26 Mar 2014, 09:46 Edited on Wed 26 Mar 2014, 10:16 Delegate Gianluigi said...

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

Thu 27 Mar 2014, 11:09 Trainer Andrew said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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