Formulas & Calculated data

[Mike C]

Anyone good with formulas? I am wanting a formula for a custom field that
looks at an outline code for say Milestone, if it exists, look at the finish
variance, if < 1 day its a "0" > 1 then its a "1"

Thanks in advance!

 

[Marc Soester]

Hi Mike C,

The formula you wrote already comes very close to the real thing

OK this is how it works:
first you will need to ensure that you have baselined your Project or task
(otherwise the finish variance cant be calculated)

Create your outline code field where you have Milestone as a choice
Create a Number field
Then create this formular within the number field:
IIf([Outline Code1]="Milestone",IIf([Finish Variance]<1,0,1),2)

Please note that you can change to number 2 in something else if you want
to. (Your question didnt state what you want to do in the event of if the
outlinecode is not "Milestone", so I just put in the 2 as a placeholder to
cover this event)

I hope this helps

 

[Mike C]

Exactly what I needed. Thanks!

Hi Mike C,

The formula you wrote already comes very close to the real thing

OK this is how it works:
first you will need to ensure that you have baselined your Project or task
(otherwise the finish variance cant be calculated)

Create your outline code field where you have Milestone as a choice
Create a Number field
Then create this formular within the number field:
IIf([Outline Code1]="Milestone",IIf([Finish Variance]<1,0,1),2)

Please note that you can change to number 2 in something else if you want
to. (Your question didnt state what you want to do in the event of if the
outlinecode is not "Milestone", so I just put in the 2 as a placeholder to
cover this event)

I hope this helps

--
Marc Soester
State Manager: EPM

Anyone good with formulas? I am wanting a formula for a custom field that
looks at an outline code for say Milestone, if it exists, look at the finish
variance, if < 1 day its a "0" > 1 then its a "1"

Thanks in advance!