Hi,
I'm using MSP2010. I have created a custom Number field to calculate Baseline Variance in Days. Problem is MSP for some reason is returning the variance to 2 decimal places i.e 2.63. Is there a way to round up or down the decimals to whole numbers??
Thanks in advance
Brian
Hi Tom,
Thanks for the response. yeah I noticed in the baseline that some activities were finished at odd times during the day i.e 12:36 and the progressed activities were finsihed at different times hence the 2.63 days variance. Now I understand what was causing it I can explain it to the PM's client.
One of the problems when picking up someone else's work!!!!
Cheers,
Brian
Hi Tom,
Thanks for the response. yeah I noticed in the baseline that some activities were finished at odd times during the day i.e 12:36 and the progressed activities were finsihed at different times hence the 2.63 days variance. Now I understand what was causing it I can explain it to the PM's client.
One of the problems when picking up someone else's work!!!!
Cheers,
Brian
Brian, MSP doesn't have a powerful rounding function. You can use Format("your formula",0) to round to the nearest integer or Format("your formula",0.0) to round to the nearest tenth. Otherwise you would be stuck with some goofy workarounds.
By the way, such fractional variances are a typical unintended result of entering date/time values (either actuals or constraints) without due care to the time of day being entered. You may want to fix such issues anyway (start by setting your default date format to one that shows time of day.) [Edit: Updating task progress using %complete combined with a status date can also cause similar results. E.g. appying 25% complete to a 5-day task sets actual duration to 1.25d and remaining duration to 3.75d. It's best to directly input actual or remaining duration instead.]
Good luck, tom