Program Comparison
In the Open Standard
Vijayasarthty SMember for 20 years 3 months
- Created
- 2
- 3
0
I have a couple of problems.
1) My Client has asked me to generate a weekly report showing the planned % Complete in MS Project. Can i do it in MSP directly (like in primavera using a target) or must i employ arithmetic formulae inserting a new field.
2) My current finish variance is being displayed as 18.34 days etc, can i eliminate this once for by doing some alterations to ensure that duration must calculated in whole numbers (days) only?.
3) As indicated above, my finish variance is being displayed in decimals. I tried using the following formulae text1 (new field) = ABS ([Finish variance]) and i got wierd values in the columns like -1051 etc, is this because MSP treats Finish Variance as a Date Field?
Regards,
Vijay
1) My Client has asked me to generate a weekly report showing the planned % Complete in MS Project. Can i do it in MSP directly (like in primavera using a target) or must i employ arithmetic formulae inserting a new field.
2) My current finish variance is being displayed as 18.34 days etc, can i eliminate this once for by doing some alterations to ensure that duration must calculated in whole numbers (days) only?.
3) As indicated above, my finish variance is being displayed in decimals. I tried using the following formulae text1 (new field) = ABS ([Finish variance]) and i got wierd values in the columns like -1051 etc, is this because MSP treats Finish Variance as a Date Field?
Regards,
Vijay
2 replies
Oldest first- 0Trevor Rabey ·This is a quick answer without checking.
1) No formula needed. Get the plan that was the version made on the day that you want to use as the reference date when the prokect plan was "as planned".
This would be the date on which you did, or should have, saved a Baseline, but if you didn’t, you just need that version.
If you don’t have that version saved, get the current version and strip all of the progress off it etc and work back to the "as planned" version on that reference date.
Then set a Status Date (Project, Project Information), which is probably today.
Show the Tracking Toolbar.
Then just select all tasks and hit the Update as scheduled button on the Tracking Toolbar.
2. The decimals are there because of the starting and finishing times, whatever calendars apply etc, and you are stuck with them.
3. MSP carries out calculations in minutes. Try ABS ([Finish variance])/480. 480 is the number of minutes in a day.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?