Přihlásit
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Syntax of formula in PWA 2010 is different than in Project Professional 2010

Obecná diskuse Syntax of formula in PWA 2010 is different than in Project Professional 2010

  • 8. dubna 2012 8:19
     
     
    Přihlásit se a hlasovat
    0

    I was surprised to see that IIF() formula works in Project Server 2010 with different separator than it works in Project Professional 2010.

    Project Professional 2010: IIF( expression , truepart , falsepart )

    Project Server 2010 (PWA): IIF( expression ; truepart ; falsepart )

    The only difference is the semicolon. I don't know whether this is documented anywhere or whether other formulas also have similar issues.

    Please correct me if I am wrong.

    Note: I have the latest updates applied.

    Tanzim Akhtar

     

Všechny reakce

  • 8. dubna 2012 15:36
     
     
    Přihlásit se a hlasovat
    1

    Don't be surprise.  That's very common in all of Microsoft products that their are slight differences or major differences.   I am actually surprise that Microsoft that there is not more, considering the size of the company and all the effort it takes to get things agreed upon.  Remember, Microsoft is not a computer but actually made up of people. LOL

    Cheers!

    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA, MCC 2011, MCC2012
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

     
  • 10. dubna 2012 11:33
     
     
    Přihlásit se a hlasovat
    0

    Hi Tanzim,

    I already noticed this behavior. Do you have same Regional Settings on the server and workstations ? 

    I just tried and I have ; as list separator in Project and in PWA as well (as specified in my regional settings).

    Clément.

     
  • 10. dubna 2012 15:28
     
     
    Přihlásit se a hlasovat
    0

    As Tanzim pointed out, this might be the result of different regional settings on server and client. Have a look at this.

    Have you tried creating the formula in Project Professional and then saving it as an Enterprise custom field from there? Would be interesting to know if the formula actually works when following this process.

     
  • 10. dubna 2012 15:39
     
     
    Přihlásit se a hlasovat
    0

    Hello Clément Comte,

    Well in fact I was doing it directly on the server and no ; as list separator.

    Tanzim Akhtar

     
  • 10. dubna 2012 15:43
     
     
    Přihlásit se a hlasovat
    0

    Shelldor,

    I came to know about the difference through this process. I was facing the syntax error issue in the PWA hence I created the formula in Project Professional 2010 and saved it as an Enterprise Field. When I went at the PWA to check the formula syntax I realised that the comma (,) was changed to semi-colon (;).

    Tanzim Akhtar

     
  • 10. dubna 2012 16:08
    Moderátor
     
     
    Přihlásit se a hlasovat
    0

    This is not a case of different syntax being required in PWA vs. Project Pro. In all three of my installations both apps require a comma. A semi-colon returns a syntax error.

    This is likely a difference in regional settings on one of the machines in your system.

    Brian Kennemer - Project MVP
    DeltaBahn Senior Architect
    endlessly obsessing about Project Server…so that you don’t have to.
    Blog | Twitter | LinkedIn