Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Decimals In Finish Variance

2 replies [Last post]
Mon, 2009-05-25 03:04
Vijayasarthty S
User offline. Last seen 6 years 21 weeks ago. Offline
Joined: 21 Jun 2006
Posts: 15
Groups: None
Dear All,

I am currently working with MSP 2007 and i find that after updating my schedule, the finish variance is getting displayed in decimals. Is there any way of rectifying it, my client is insisting in a finish variance without decimals and the gant chart together.
Kindly reply it this is possible to be done in MSP.

Regards,

Vijay
Top

Replies

Fri, 2009-05-29 08:39
#1
Vijayasarthty S
User offline. Last seen 6 years 21 weeks ago. Offline
Joined: 21 Jun 2006
Posts: 15
Groups: None
Thanks for your response, i will try the same and check how my client responds to it, i will post the result on the fopum too.

Regards,

Vijay
Top
Fri, 2009-05-29 04:34
#2
Darren Kosa
User offline. Last seen 7 years 31 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Hi Vijay,

I use a pretty simple formula to round up Work, so I’ve adapted it to do the same with Finish Variance for you.

Tools > Customize > Fields

Select a spare Text Field to customise and copy and paste this formula.

ROUND([Finish Variance]/480) & " days"

Hopefully this is what you’re after.

Regards,

Darren
Top