Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Project Server is not working properly RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    MS and PWA is not picking the indicator from the formula. like formula is as

    IIf([Agreement Signed (B)] = ProjDateValue("NA"), "Not Baselined", IIf([Agreement Signed (A)] = ProjDateValue("NA"), IIf(Now() > [Agreement Signed (C)], "Not Updated", IIf([Agreement Signed (C)] - [Agreement Signed (B)] <= 0, "On Time", IIf([Agreement Signed (C)] - [Agreement Signed (B)] <= 30, "Somewhat Late", "Late"))), IIf([Agreement Signed (A)] - [Agreement Signed (B)] <= 0, "Finished OnTime", IIf([Agreement Signed (A)] - [Agreement Signed (B)] <= 30, "Finished Somewhat Late", "Finished Late"))))

    but msp as well as pwa is not updating in case of "Not Updated" indicator,Please help.

    Tuesday, June 16, 2015 3:23 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Ashish,

    Rather than me try and unravel this formula, what I suggest you do is start from basics again with the formula in MSP.  As a tip, you may wish to use the SWITCH statement as I understand that the logic of nested IIFs can become confusing. 

    Ben Howard [MVP] | web | blog | book | P2O

    Tuesday, June 16, 2015 8:20 AM