- This topic has 5 replies, 2 voices, and was last updated 11 months, 4 weeks ago by Thomas Boyle.
- 08/13/2019 at 9:49 pm #416249Dzeke R.Guest
Hi, I am trying to create a custom fields that will show the % of the summary task duration to the overall summary task duration. Not quite able to relate it to the main summary task in the formula field. Any tips?08/14/2019 at 9:15 am #416251Larry ChristofaroParticipant
Hi Dzeke. I’m not sure you can do that (at least not easily). I looked at the Stop field that contains when the completed part of the task ends, and it doesn’t work as you might expect for the summary task. There might be another option but I can’t think of it right off. Maybe someone can pipe in to the thread. Good luck.08/14/2019 at 10:10 am #416252Thomas BoyleGuest
Not sure if you are looking for a %complete or a simple ratio of durations – i.e. how much of the overall project duration is represented by each summary task.
In case of the latter, you can try this:
Format(IIf([Summary],[Duration]/ProjDateDiff([Project Start],[Project Finish],[Project Calendar])*100,0),”0.00″) & “%”
Good luck, tom08/14/2019 at 10:11 am #416253Thomas BoyleGuest
That’s for a custom text field. Also make sure that the calculation for summary rows is set to “Use formula.”08/14/2019 at 8:37 pm #416262Dzeke R.Guest
Yup that is exactly what I am looking for. But I tried the formula on the custom text fields but it displays syntax error. “contains a reference to an unrecognized field or function name”. Should I add/delete anything to the formula?
This is actually my first time using custom fields and tried troubleshooting the formula to no avail.
Thanks08/15/2019 at 11:27 am #416266Thomas BoyleGuest
Try deleting and re-typing the quotation marks. (Formulas recognize the non-direction marks, but pasting to and from this web page tends to convert some of them to directional marks, i.e. opening and closing.)
Good luck, tom