Finish Variance-Decimals

[Jackie]

I am currently getting decimals in my finish variances. I cannot find anyone
to make it give only whole numbers. Is it possible? Or how do I make it give
me whole numbers? I can get some whole numbers by adjusting the durations,
but sometimes I get .01 or -.01 and can't get 0

 

[Dale Howard [MVP]]

Jackie --

No, it is not possible to round Finish Variance to a whole number. Sorry.

 

[Tom Mc]

Hello Jackie,

It is true that you cannot round numbers in the canned field "Finish
Variance". However, you can work around this by putting a formula in a
custom number field as follows:

Fix([Finish]-[Baseline Finish])

Note: this custom formula does not take into account any project calendars
and calculates as if there were a 7-day workweek calendar. If you want the
Variance to be converted to a 5-day workweek, simply multiply by 5/7

Hope this helps!

Tom Mc

 

[Matt M]

Tom-

Your formula achieved a similar result to what I'm looking for. When
creating a project, I do a baseline. I have the baseline column showing. I
created a custom column called "Days Late" with your formula. If a client is
a day late, everything pushes out compared to the baseline and the "days
late" column shows the days late for each corresponding task. The problem
occurs (to your point) when, for example, the weekend comes. If the client
is 1 day late on a friday, additional tasks show 3 days late as they factor
in saturday and sunday plus monday. I don't totally understand your 5/7
point. Any thoughts?

Thanks,
Matt

Hello Jackie,

It is true that you cannot round numbers in the canned field "Finish
Variance". However, you can work around this by putting a formula in a
custom number field as follows:

Fix([Finish]-[Baseline Finish])

Note: this custom formula does not take into account any project calendars
and calculates as if there were a 7-day workweek calendar. If you want the
Variance to be converted to a 5-day workweek, simply multiply by 5/7

Hope this helps!

Tom Mc

Jackie --

No, it is not possible to round Finish Variance to a whole number. Sorry.