none
adding calculated fileds RRS feed

  • 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)

    as long as I dont add the extra full month - I receive nice alerts. when I add to the formula the 22 - I receive nothing.

     

    my furmula is:

     

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

     

    can you help me please?

     

    Thanks,

    Hanni


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

Answers

  • 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)
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky
    Thursday, March 3, 2011 2:16 PM
    Moderator

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)
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky
    Thursday, March 3, 2011 2:16 PM
    Moderator
  • 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)
     
     

    Andrew Lavinsky [MVP] Twitter: @alavinsky
    Thursday, March 3, 2011 3:34 PM
    Moderator
  • Thanks...

     

    good idea

     

    I will try and hopefully report for success :-)


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