8. dubna 2012 8:19
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.
8. dubna 2012 15:36
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
Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA, MCC 2011, MCC2012
Blog http://MyProjectExpert.com contains my field notes and SQL queries
10. dubna 2012 11:33
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).
10. dubna 2012 15:28
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
Hello Clément Comte,
Well in fact I was doing it directly on the server and no ; as list separator.
10. dubna 2012 15:43
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 (;).
10. dubna 2012 16:08Moderátor
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.