Custom Variance fields

[Michelle Moulliet]

I tried to set up a custom variance field by using a custom duration field
and the following formula:

[Finish] - [Baseline1 Finish]

I get nothing but 0 days no matter what data I put in either field. Does
anyone
have any suggestions why it's not working?

 

[John]

I tried to set up a custom variance field by using a custom duration field
and the following formula:

[Finish] - [Baseline1 Finish]

I get nothing but 0 days no matter what data I put in either field. Does
anyone
have any suggestions why it's not working?

Michelle,
That's because the formula is working with dates and the spare duration
fields only recognize time span. Try the following formula instead (the
variance will be shown in working days).
ProjDateDiff([Baseline1 Finish],[Finish])

Hope this helps.
John
Project MVP

 

[Michelle Moulliet]

Thanks!

I tried to set up a custom variance field by using a custom duration field
and the following formula:

[Finish] - [Baseline1 Finish]

I get nothing but 0 days no matter what data I put in either field. Does
anyone
have any suggestions why it's not working?

Michelle,
That's because the formula is working with dates and the spare duration
fields only recognize time span. Try the following formula instead (the
variance will be shown in working days).
ProjDateDiff([Baseline1 Finish],[Finish])

Hope this helps.
John
Project MVP

 

[John]

Thanks!

I tried to set up a custom variance field by using a custom duration
field
and the following formula:

[Finish] - [Baseline1 Finish]

I get nothing but 0 days no matter what data I put in either field. Does
anyone
have any suggestions why it's not working?

Michelle,
That's because the formula is working with dates and the spare duration
fields only recognize time span. Try the following formula instead (the
variance will be shown in working days).
ProjDateDiff([Baseline1 Finish],[Finish])

Hope this helps.
John
Project MVP

Michelle,
You're welcome.
John