Formula Finish Variance
in [Project]
|
Prev: Microsoft project resources
Next: URGENT
From: JulieS on 6 Apr 2010 19:39 You are most welcome Rita. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project On 4/6/2010 7:29 AM, ProjectRita wrote: > 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 >>>>>>> >>>>>> >>>>>> >>>>>> . >>>>>> >> . >> |