Adjust Graphical Indicator formula to Milestone %complete RRS feed

  • Question

  • Hello, I was wondering how I would reflect the following formula to adjust the % complete on a milesone task.

    IIf([Finish]<=Date() And [% Complete]<>100,2,IIf([Start]<=Date() And [% Complete]=0,1,IIf([% Complete]=100,3,0)))

    For example, It would make sense to have the milestone %Complete, "Financial Plan Completed" to match the Summary task % Compelete. Correct?

    % Complete Status Task Name
    50% 3 Finalize Financial Plan
    50% 2    Update Financial Plan
    0% 2    Financial Plan Completed
    Monday, March 11, 2013 10:37 PM