Formula Finish Variance

[ProjectRita]

Hi everyone...
This is probably real simple for you, but i think i`m loosing to much time
looking for the answer!
I`m trying to do a simple custom field with a formula, that gives me the
finish variance [Early Finish]-[Baseline3 Finish], i have tried to use finish
custom field type, the date and even the duration type...it keeps given me
ERROR...could someone help me with this?
Thanks,

Rita

 

[Gérard Ducouret]

Hi Rita,

Make sure you have any data in [Baseline3 Finish].

Gérard Ducouret

 

[Andrew Lavinsky]

Try a duration field with the following formula:

IIf([Baseline3 Finish]=ProjDateValue('NA'),0,ProjDateDiff([Baseline3 Finish],[Early
Finish]))

That will display "0" if the Baseline3 Finish field is blank.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[ProjectRita]

Thanks

It`s working now...It seems that i have to use a special function to do the
diffrence between dates, and give me back a duration (ProjDateValue)
Could someone give me the instructions to use the right functions in the
right custom fields types? Because i had already tried the function DateDiff
(wich i think would give the difference with date units), and it didn`t work
out.

thanks a lot

Rita

Try a duration field with the following formula:

IIf([Baseline3 Finish]=ProjDateValue('NA'),0,ProjDateDiff([Baseline3 Finish],[Early
Finish]))

That will display "0" if the Baseline3 Finish field is blank.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi everyone...
This is probably real simple for you, but i think i`m loosing to much
time
looking for the answer!
I`m trying to do a simple custom field with a formula, that gives me
the
finish variance [Early Finish]-[Baseline3 Finish], i have tried to use
finish
custom field type, the date and even the duration type...it keeps
given me
ERROR...could someone help me with this?
Thanks,
Rita

.

 

[Jim Aksel]

I am going to step away from my peers on this one a little bit. First, their
solutions work and can be used without problems.

We do it a little bit differently. Assuming that your Earned Value Baseline
is set, you would be taking your Earned Value against Baseline 3 data.
Therefore, Tools/Options/Calculations (tab). Select Earned Value and set the
"Baseline used for Earned Value Calculations" to Baseline3 from the drop
down. Select OK.

The values for duration variances (start, duratin, finish) and cost
variances (CV, CV%, etc) are calculated against the baseline set in the
earned value calculations settings.

Now, insert the field "Finish Variance" in your schedule. It
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Andrew Lavinsky]

That's a pretty broad question you're asking. It's kind of like asking in
Excel which formulas work with which cell formatting types. Your best bet
is to go to the help menu, type in formula, and see the options.

ProjDateDiff calculates the difference (in working days) between two dates.
It's typically (but not always) used to display a duration. You could also
use it in a text field, or as part of an if-then clause in a flag field (among
other examples).

The syntax is ProjDateDiff([Date1],[Date2],Calendar), where the Calendar
defaults to the Project Calendar unless otherwise specifified. The calculation
may throw errors if either Date1 or Date2 are unspecified.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Thanks

It`s working now...It seems that i have to use a special function to
do the
diffrence between dates, and give me back a duration (ProjDateValue)
Could someone give me the instructions to use the right functions in
the
right custom fields types? Because i had already tried the function
DateDiff
(wich i think would give the difference with date units), and it
didn`t work
out.
thanks a lot

Rita

Try a duration field with the following formula:

IIf([Baseline3 Finish]=ProjDateValue('NA'),0,ProjDateDiff([Baseline3
Finish],[Early Finish]))

That will display "0" if the Baseline3 Finish field is blank.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi everyone...
This is probably real simple for you, but i think i`m loosing to
much
time
looking for the answer!
I`m trying to do a simple custom field with a formula, that gives me
the
finish variance [Early Finish]-[Baseline3 Finish], i have tried to
use
finish
custom field type, the date and even the duration type...it keeps
given me
ERROR...could someone help me with this?
Thanks,
Rita

.

 

[Jim Aksel]

That is a pretty big question. You can read about the "return type" for each
custom field by inserting the column and then hovering over it. For example,
if you insert Date1 and then hover over it, you get a choice "Help on
Date1".. If you open that hyperlink, it will tell you about the return
types, etc.

One thing to note, dates in Project are of type Variant, not "Date" ....
same with duration. So when you look at a formula such as "ProjDateDiff" it
is exepcting something that evaluates to "Date" instead of "Variant" or
"Object". In your specific case, BaselineFinish3 might have the value NA
which is not of type date.

See my other post for a different procedure.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Thanks

It`s working now...It seems that i have to use a special function to do the
diffrence between dates, and give me back a duration (ProjDateValue)
Could someone give me the instructions to use the right functions in the
right custom fields types? Because i had already tried the function DateDiff
(wich i think would give the difference with date units), and it didn`t work
out.

thanks a lot

Rita

Try a duration field with the following formula:

IIf([Baseline3 Finish]=ProjDateValue('NA'),0,ProjDateDiff([Baseline3 Finish],[Early
Finish]))

That will display "0" if the Baseline3 Finish field is blank.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi everyone...
This is probably real simple for you, but i think i`m loosing to much
time
looking for the answer!
I`m trying to do a simple custom field with a formula, that gives me
the
finish variance [Early Finish]-[Baseline3 Finish], i have tried to use
finish
custom field type, the date and even the duration type...it keeps
given me
ERROR...could someone help me with this?
Thanks,
Rita

.

 

[ProjectRita]

thanks ...

Well...i think my question was a little bit out, i wasn`t thinking that
anyone could give me an answer with 2 or 3 lines...i was trying to know if
there was any tutorials that i could study from. I will explore the help menu
and try to run some more tests...i hope you help me in the next question...
I`m sorry, but my english is a little bit stucked ...

see you soon...and thanks a lot again

Rita

That is a pretty big question. You can read about the "return type" for each
custom field by inserting the column and then hovering over it. For example,
if you insert Date1 and then hover over it, you get a choice "Help on
Date1".. If you open that hyperlink, it will tell you about the return
types, etc.

One thing to note, dates in Project are of type Variant, not "Date" ....
same with duration. So when you look at a formula such as "ProjDateDiff" it
is exepcting something that evaluates to "Date" instead of "Variant" or
"Object". In your specific case, BaselineFinish3 might have the value NA
which is not of type date.

See my other post for a different procedure.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Thanks

It`s working now...It seems that i have to use a special function to do the
diffrence between dates, and give me back a duration (ProjDateValue)
Could someone give me the instructions to use the right functions in the
right custom fields types? Because i had already tried the function DateDiff
(wich i think would give the difference with date units), and it didn`t work
out.

thanks a lot

Rita

Try a duration field with the following formula:

IIf([Baseline3 Finish]=ProjDateValue('NA'),0,ProjDateDiff([Baseline3 Finish],[Early
Finish]))

That will display "0" if the Baseline3 Finish field is blank.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi everyone...
This is probably real simple for you, but i think i`m loosing to much
time
looking for the answer!
I`m trying to do a simple custom field with a formula, that gives me
the
finish variance [Early Finish]-[Baseline3 Finish], i have tried to use
finish
custom field type, the date and even the duration type...it keeps
given me
ERROR...could someone help me with this?
Thanks,
Rita



.

 

[JulieS]

Hello ProjectRita,

Fellow MVP, Jack Dahlgren has a great page of information with
some common custom fields:

http://masamiki.com/project/customfieldFAQ.htm

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

thanks ...

Well...i think my question was a little bit out, i wasn`t thinking that
anyone could give me an answer with 2 or 3 lines...i was trying to know if
there was any tutorials that i could study from. I will explore the help menu
and try to run some more tests...i hope you help me in the next question...
I`m sorry, but my english is a little bit stucked ...

see you soon...and thanks a lot again

Rita

That is a pretty big question. You can read about the "return type" for each
custom field by inserting the column and then hovering over it. For example,
if you insert Date1 and then hover over it, you get a choice "Help on
Date1".. If you open that hyperlink, it will tell you about the return
types, etc.

One thing to note, dates in Project are of type Variant, not "Date" ....
same with duration. So when you look at a formula such as "ProjDateDiff" it
is exepcting something that evaluates to "Date" instead of "Variant" or
"Object". In your specific case, BaselineFinish3 might have the value NA
which is not of type date.

See my other post for a different procedure.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Thanks

It`s working now...It seems that i have to use a special function to do the
diffrence between dates, and give me back a duration (ProjDateValue)
Could someone give me the instructions to use the right functions in the
right custom fields types? Because i had already tried the function DateDiff
(wich i think would give the difference with date units), and it didn`t work
out.

thanks a lot

Rita
:

Try a duration field with the following formula:

IIf([Baseline3 Finish]=ProjDateValue('NA'),0,ProjDateDiff([Baseline3 Finish],[Early
Finish]))

That will display "0" if the Baseline3 Finish field is blank.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi everyone...
This is probably real simple for you, but i think i`m loosing to much
time
looking for the answer!
I`m trying to do a simple custom field with a formula, that gives me
the
finish variance [Early Finish]-[Baseline3 Finish], i have tried to use
finish
custom field type, the date and even the duration type...it keeps
given me
ERROR...could someone help me with this?
Thanks,
Rita



.

 

[ProjectRita]

Thanks for the tip Julie...
That site looks great...
See you soon

Rita


"JulieS" escreveu:

Hello ProjectRita,

Fellow MVP, Jack Dahlgren has a great page of information with
some common custom fields:

http://masamiki.com/project/customfieldFAQ.htm

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

thanks ...

Well...i think my question was a little bit out, i wasn`t thinking that
anyone could give me an answer with 2 or 3 lines...i was trying to know if
there was any tutorials that i could study from. I will explore the help menu
and try to run some more tests...i hope you help me in the next question...
I`m sorry, but my english is a little bit stucked ...

see you soon...and thanks a lot again

Rita

That is a pretty big question. You can read about the "return type" for each
custom field by inserting the column and then hovering over it. For example,
if you insert Date1 and then hover over it, you get a choice "Help on
Date1".. If you open that hyperlink, it will tell you about the return
types, etc.

One thing to note, dates in Project are of type Variant, not "Date" ....
same with duration. So when you look at a formula such as "ProjDateDiff" it
is exepcting something that evaluates to "Date" instead of "Variant" or
"Object". In your specific case, BaselineFinish3 might have the value NA
which is not of type date.

See my other post for a different procedure.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com



:

Thanks

It`s working now...It seems that i have to use a special function to do the
diffrence between dates, and give me back a duration (ProjDateValue)
Could someone give me the instructions to use the right functions in the
right custom fields types? Because i had already tried the function DateDiff
(wich i think would give the difference with date units), and it didn`t work
out.

thanks a lot

Rita
:

Try a duration field with the following formula:

IIf([Baseline3 Finish]=ProjDateValue('NA'),0,ProjDateDiff([Baseline3 Finish],[Early
Finish]))

That will display "0" if the Baseline3 Finish field is blank.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi everyone...
This is probably real simple for you, but i think i`m loosing to much
time
looking for the answer!
I`m trying to do a simple custom field with a formula, that gives me
the
finish variance [Early Finish]-[Baseline3 Finish], i have tried to use
finish
custom field type, the date and even the duration type...it keeps
given me
ERROR...could someone help me with this?
Thanks,
Rita



.

.

 

[JulieS]

You are most welcome Rita.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

Thanks for the tip Julie...
That site looks great...
See you soon

Rita


"JulieS" escreveu:

Hello ProjectRita,

Fellow MVP, Jack Dahlgren has a great page of information with
some common custom fields:

http://masamiki.com/project/customfieldFAQ.htm

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

thanks ...

Well...i think my question was a little bit out, i wasn`t thinking that
anyone could give me an answer with 2 or 3 lines...i was trying to know if
there was any tutorials that i could study from. I will explore the help menu
and try to run some more tests...i hope you help me in the next question...
I`m sorry, but my english is a little bit stucked ...

see you soon...and thanks a lot again

Rita

:

That is a pretty big question. You can read about the "return type" for each
custom field by inserting the column and then hovering over it. For example,
if you insert Date1 and then hover over it, you get a choice "Help on
Date1".. If you open that hyperlink, it will tell you about the return
types, etc.

One thing to note, dates in Project are of type Variant, not "Date" ....
same with duration. So when you look at a formula such as "ProjDateDiff" it
is exepcting something that evaluates to "Date" instead of "Variant" or
"Object". In your specific case, BaselineFinish3 might have the value NA
which is not of type date.

See my other post for a different procedure.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com



:

Thanks

It`s working now...It seems that i have to use a special function to do the
diffrence between dates, and give me back a duration (ProjDateValue)
Could someone give me the instructions to use the right functions in the
right custom fields types? Because i had already tried the function DateDiff
(wich i think would give the difference with date units), and it didn`t work
out.

thanks a lot

Rita
:

Try a duration field with the following formula:

IIf([Baseline3 Finish]=ProjDateValue('NA'),0,ProjDateDiff([Baseline3 Finish],[Early
Finish]))

That will display "0" if the Baseline3 Finish field is blank.


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

Hi everyone...
This is probably real simple for you, but i think i`m loosing to much
time
looking for the answer!
I`m trying to do a simple custom field with a formula, that gives me
the
finish variance [Early Finish]-[Baseline3 Finish], i have tried to use
finish
custom field type, the date and even the duration type...it keeps
given me
ERROR...could someone help me with this?
Thanks,
Rita



.

.