Calculating variance in days

[David Luper]

I want to create a calculated field that compares Finish with a Baseline
Finish. If the Baseline Finish is less than or equal to Finish, then the
field would be blank. If Baseline Finish is greater than Finish, then the
field would show the number of days. Any ideas? Can anyone suggest good
resources for calculated fields?

Thanks!
David

 

[Dale Howard [MVP]]

David --

I'm trying to figure out what you are trying to show. If the Baseline
Finish date is less than or equal to the Finish date, then the task is going
to finish late. Why would you want to show no value for that situation? If
the Baseline Finish is greater than the Finish date, then this means the
task is going to finish early. Why would you want to show the number of
days for that situation, since the number will be a negative value? Anyway,
here's how you would create the formula:

1. Select and rename a custom task Text field
2. Put the following formula in that custom task Text field:

IIf([Finish Variance]>=0,"",[Finish Variance]/480 & " d")

Hope this helps.

 

[David Luper]

Dale,

Thanks for the response.

I guess I was thinking about it in English as opposed to Project
calculations. For instance,

Finish = 1/31/06 (representing the projected finish date for the task)

Deadline = 1/30/06 (representing the "contractual" finish date for the task)

Variance in Days = 1

If, on the other hand,

Finish = 1/30/06 (representing the projected finish date for the task)

Deadline = 1/31/06 (representing the "contractual" finish date for the task)

Variance in Days = NA (or something)

Does that make more sense?

Thanks!
David

David --

I'm trying to figure out what you are trying to show. If the Baseline
Finish date is less than or equal to the Finish date, then the task is going
to finish late. Why would you want to show no value for that situation? If
the Baseline Finish is greater than the Finish date, then this means the
task is going to finish early. Why would you want to show the number of
days for that situation, since the number will be a negative value? Anyway,
here's how you would create the formula:

1. Select and rename a custom task Text field
2. Put the following formula in that custom task Text field:

IIf([Finish Variance]>=0,"",[Finish Variance]/480 & " d")

Hope this helps.

I want to create a calculated field that compares Finish with a Baseline
Finish. If the Baseline Finish is less than or equal to Finish, then the
field would be blank. If Baseline Finish is greater than Finish, then the
field would show the number of days. Any ideas? Can anyone suggest good
resources for calculated fields?

Thanks!
David

 

[Dale Howard [MVP]]

David --

Yes, I understand. You simply stated it backwards. If that is the case,
the formula would look like this:

IIf([Finish Variance]<=0,"",[Finish Variance]/480 & " d")

Hope this helps.

Dale,

Thanks for the response.

I guess I was thinking about it in English as opposed to Project
calculations. For instance,

Finish = 1/31/06 (representing the projected finish date for the task)

Deadline = 1/30/06 (representing the "contractual" finish date for the
task)

Variance in Days = 1

If, on the other hand,

Finish = 1/30/06 (representing the projected finish date for the task)

Deadline = 1/31/06 (representing the "contractual" finish date for the
task)

Variance in Days = NA (or something)

Does that make more sense?

Thanks!
David

David --

I'm trying to figure out what you are trying to show. If the Baseline
Finish date is less than or equal to the Finish date, then the task is
going
to finish late. Why would you want to show no value for that situation?
If
the Baseline Finish is greater than the Finish date, then this means the
task is going to finish early. Why would you want to show the number of
days for that situation, since the number will be a negative value?
Anyway,
here's how you would create the formula:

1. Select and rename a custom task Text field
2. Put the following formula in that custom task Text field:

IIf([Finish Variance]>=0,"",[Finish Variance]/480 & " d")

Hope this helps.

I want to create a calculated field that compares Finish with a Baseline
Finish. If the Baseline Finish is less than or equal to Finish, then
the
field would be blank. If Baseline Finish is greater than Finish, then
the
field would show the number of days. Any ideas? Can anyone suggest
good
resources for calculated fields?

Thanks!
David

 

[David Luper]

Dale -

Thanks very much.

I will give it a try.

David

David --

Yes, I understand. You simply stated it backwards. If that is the case,
the formula would look like this:

IIf([Finish Variance]<=0,"",[Finish Variance]/480 & " d")

Hope this helps.

Dale,

Thanks for the response.

I guess I was thinking about it in English as opposed to Project
calculations. For instance,

Finish = 1/31/06 (representing the projected finish date for the task)

Deadline = 1/30/06 (representing the "contractual" finish date for the
task)

Variance in Days = 1

If, on the other hand,

Finish = 1/30/06 (representing the projected finish date for the task)

Deadline = 1/31/06 (representing the "contractual" finish date for the
task)

Variance in Days = NA (or something)

Does that make more sense?

Thanks!
David

David --

I'm trying to figure out what you are trying to show. If the Baseline
Finish date is less than or equal to the Finish date, then the task is
going
to finish late. Why would you want to show no value for that situation?
If
the Baseline Finish is greater than the Finish date, then this means the
task is going to finish early. Why would you want to show the number of
days for that situation, since the number will be a negative value?
Anyway,
here's how you would create the formula:

1. Select and rename a custom task Text field
2. Put the following formula in that custom task Text field:

IIf([Finish Variance]>=0,"",[Finish Variance]/480 & " d")

Hope this helps.




I want to create a calculated field that compares Finish with a Baseline
Finish. If the Baseline Finish is less than or equal to Finish, then
the
field would be blank. If Baseline Finish is greater than Finish, then
the
field would show the number of days. Any ideas? Can anyone suggest
good
resources for calculated fields?

Thanks!
David