98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Medium Priority · Version 2007
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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Entering DaysTo 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. |