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
