Home Forums Discussion Custom %

This topic contains 5 replies, has 2 voices, and was last updated by  Thomas Boyle 1 month ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #416249 Reply

    Dzeke R.

    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?

    #416251 Reply
    Larry Christofaro
    Larry Christofaro
    Participant
    • Expert
    • Forum Pro
    • Ombud

    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.

    #416252 Reply

    Thomas Boyle

    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, tom

    #416253 Reply

    Thomas Boyle

    That’s for a custom text field. Also make sure that the calculation for summary rows is set to “Use formula.”

    #416262 Reply

    Dzeke R.

    Hey Tom,

    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.

    Thanks

    #416266 Reply

    Thomas Boyle

    Hi Dzeke,
    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

Viewing 6 posts - 1 through 6 (of 6 total)
Reply To: Custom %
Your information:




29 − = 20