• ### Question

• Hi,

I would like to add a field that will alert me when the finish date is on delay comparinf to baseline finish + 30 edays (full month)

my furmula is:

iif ([start variance]+22>0,1,0)

Thanks,

Hanni

Hanni, PMO
Thursday, March 3, 2011 2:07 PM

• Project calculates duration in minutes.  When you add "22," you're adding
22 minutes.  The easiest solution is to take 22 X 8 hours X 60 minutes =
10,560.

So the solution would be IIF([Finish Variance]<10560,0,1)

Thursday, March 3, 2011 2:16 PM

### All replies

• Project calculates duration in minutes.  When you add "22," you're adding
22 minutes.  The easiest solution is to take 22 X 8 hours X 60 minutes =
10,560.

So the solution would be IIF([Finish Variance]<10560,0,1)

Thursday, March 3, 2011 2:16 PM
• Thanks- and do you recommend to set this calculated field as Number Or Text filed (the result need to be 1 or 0 and I use grfilcal indicators)

and also, why can I see the 1 or 0 when I want to sort or filter this filed?

Thanks again,

Hanni

Hanni, PMO
Thursday, March 3, 2011 2:34 PM
• I would use a flag field, which only allows Yes/No values.

Something like IIF([Finish Variance]>x,Yes,No)

Thursday, March 3, 2011 3:34 PM
• Thanks...

good idea

I will try and hopefully report for success :-)

Hanni, PMO
Thursday, March 3, 2011 3:59 PM