Hi Ruben, have done something like this before, and used the formula [% Complete]-Val([Text28]) & "%" to subtract planned from actual % where Text28 contains the % Planned, seems to work. You could then easily set another Text field to display graphics by setting values against test for the results.
Hope this helps you.
Regards
Ian
Member for
11 years 7 months
Member for11 years7 months
Submitted by Aussiechilean on Mon, 2014-03-24 13:57
yes, % planned of what needs to be completed up to the date I am consulting.
To give you some context, in order to calculate the % of planned worked in project, what I do is insert a text column (which will be my % planned column). I then press the "update project" button on the project tab which will update the percentages of each activity of my % complete column. It will indicate how much progress I should be reporting for the date I am consulting for each activity. I then copy the results of that column (% complete) and copy it onto my % planned column. This gives me a reference of what % I should be at, in other words, my planned percentage. I then manually update my % complete column with the real % of advancement I am at with each activity. For example, for a given activity, project might report that I should be at 50% based on the date I am consulting, but the reality is that I am 30% which would mean I am behind schedule. Given the aforementioned, I wish to have 3 indicators to report if i'm on target, 1%-10% behind schedule or greater than 10% behind schedule. To do this I believe I would need a formula I can use to calculate if for each activity if I am green, yellow or red.
Member for
11 years 7 monthsSomething along the lines
Something along the lines of:
IIf([% Complete]-Val([Text28])<=-10,”Red”,IIf([% Complete]-Val([Text28])<=-1,”Amber”,”Green”))
should do the trick?
Regards, Ian
Member for
11 years 7 monthsSomething along the lines
Something along the lines of:
IIf([% Complete]-Val([Text28])<=-10,”Red”,IIf([% Complete]-Val([Text28])<=-1,”Amber”,”Green”))
should do the trick?
Regards, Ian
Member for
11 years 7 monthsHi Ruben, have done something
Hi Ruben, have done something like this before, and used the formula [% Complete]-Val([Text28]) & "%" to subtract planned from actual % where Text28 contains the % Planned, seems to work. You could then easily set another Text field to display graphics by setting values against test for the results.
Hope this helps you.
Regards
Ian
Member for
11 years 7 monthsyes, % planned of what needs
yes, % planned of what needs to be completed up to the date I am consulting.
To give you some context, in order to calculate the % of planned worked in project, what I do is insert a text column (which will be my % planned column). I then press the "update project" button on the project tab which will update the percentages of each activity of my % complete column. It will indicate how much progress I should be reporting for the date I am consulting for each activity. I then copy the results of that column (% complete) and copy it onto my % planned column. This gives me a reference of what % I should be at, in other words, my planned percentage. I then manually update my % complete column with the real % of advancement I am at with each activity. For example, for a given activity, project might report that I should be at 50% based on the date I am consulting, but the reality is that I am 30% which would mean I am behind schedule. Given the aforementioned, I wish to have 3 indicators to report if i'm on target, 1%-10% behind schedule or greater than 10% behind schedule. To do this I believe I would need a formula I can use to calculate if for each activity if I am green, yellow or red.
I hope this clears the doubt.
Any ideas?
Thanks
Ruben
Member for
19 years 1 monthplanned % in MS Project? was
planned % in MS Project? was it coming from your baseline schedule or your current schedule? and how about planned % considering early or late?