Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2010, 02:40 AM
poyns poyns is offline Help with Interim Baseline Variance Windows XP Help with Interim Baseline Variance Office 2003
Novice
Help with Interim Baseline Variance
 
Join Date: May 2010
Posts: 1
poyns is on a distinguished road
Default Help with Interim Baseline Variance

Hello



I'm not so hot on the advanced side of project so I was hoping someone could help explain how to do something (in fairly simple terms if possible)?

I've changed the view of a plan to Table:Variance so I can review the variance from the Baseline Finish date. We are also capturing an Interim baseline and need to also calculate the variance of each task from the respective Finish1, Finish2, Finish3 fields.

The Table: Variance view doesn't give you the option to perform this report and further research online seems to suggest using a calculation. Excuse my ignorance but I didn't even know you could input calculations into Project!

Can someone please explain what steps I need to follow to get this information as easily as possible?

It's MUCH appreciated!

Thanks
Laura
Reply With Quote
  #2  
Old 05-27-2010, 10:59 AM
Kimberly Kimberly is offline Help with Interim Baseline Variance Windows 7 Help with Interim Baseline Variance Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Tools > Customize Fields
Field type is Duration.
Click the Rename button if you want to rename it.
Choose the Formula radio button then click the Formula button
The formula is:
ProjDateDiff([Finish],[Finish1],"standard")

The 3rd argument is the calendar. if you don't use the standard calendar, put your calendar name there instead.

Then you will need to Insert the field in the table.
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft