Cumulative % Complete Formula

[colegwu13]

Not sure if this is possible as I was presented with an odd request:

I am attempting to write a formula that adds up the percent complete of tasks in the file by UID to calculate the cumulative percent complete for a task representing other tasks throughout the IMS, which are not subtasks of the task with the formula.

Not looking to do the grouping feature, yet know that feature could do that and I could then input the value in the 'task representing other tasks throughout the IMS, which are not subtasks of the task with the formula.'.

Cheers,

Cole

[#2]

@colegwu13 

Maybe. Conceptually I can envision setting up a flag field to designate which tasks to include in this "metric". Then use two custom number fields to capture the Duration and Actual Duration values for tasks with the flag field set. Sum those values up to summary level and calculate the percent complete.

If your "task with the formula" is not a summary level, then none of this can be done with custom field formulas.

You do realize that percent complete is duration based and the passage of time (i.e. duration) accomplishes nothing, except for concrete curing, paint drying, or wounds healing. So you are correct in that this is a very odd request and will produce an even more meaningless metric for a questionable starting metric. My thoughts.

John

[#3]

Thanks for your thoughts; appreciate the sounding board. I'll take a stab at it. for now, I'm using the grouping feature which I can verify my results.

[#4]

@colegwu13 

You're welcome and thanks for the feedback.

John