Formula Finish Variance
in [Project]
|
Prev: Microsoft project resources
Next: URGENT
From: Andrew Lavinsky on 5 Apr 2010 13:26 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 > "Andrew Lavinsky" wrote: >> 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 >> . >>
From: Jim Aksel on 5 Apr 2010 14:13 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 "ProjectRita" wrote: > 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 > "Andrew Lavinsky" wrote: > > > 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 > > > > > > > > > . > >
From: ProjectRita on 5 Apr 2010 19:29 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 "Jim Aksel" wrote: > 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 > > > > "ProjectRita" wrote: > > > 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 > > "Andrew Lavinsky" wrote: > > > > > 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 > > > > > > > > > > > > > . > > >
From: JulieS on 5 Apr 2010 19:56 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 On 4/5/2010 7:29 PM, ProjectRita wrote: > 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 > > "Jim Aksel" wrote: > >> 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 >> >> >> >> "ProjectRita" wrote: >> >>> 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 >>> "Andrew Lavinsky" wrote: >>> >>>> 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 >>>>> >>>> >>>> >>>> . >>>>
From: ProjectRita on 6 Apr 2010 07:29
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 > > On 4/5/2010 7:29 PM, ProjectRita wrote: > > 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 > > > > "Jim Aksel" wrote: > > > >> 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 > >> > >> > >> > >> "ProjectRita" wrote: > >> > >>> 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 > >>> "Andrew Lavinsky" wrote: > >>> > >>>> 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 > >>>>> > >>>> > >>>> > >>>> . > >>>> > . > |