PS2010 'LIKE' operator

[Andrew Dover]

I'm doing some work manually transcribing a PS2007 configuration to PS2010
(an opportunity to review the config amongst other things), however am
getting the message 'The formula contains errors' from PWA when I try to save
one of the Enterprise Custom fields. The formula contains 'LIKE' and this
seems to be what is tripping it up. I've created a simple formula in
standalone Project 2010:

IIf([Text1] Like "completed*","Yes","No")

And it works just fine. Repeating this in PWA 2010 results in the error.
Could this be a variance in the validation of PWA and standalone Project?
Anyone got a workaround for this? Could this be a defect?

 

[Andrew Lavinsky]

This formula should do pretty much the same thing and work with Server:

IIf(INSTR([Text1],"Completed")>0,Yes,No)

Also note that this newsgroup is getting shut down, and future posts should
go here: http://social.technet.microsoft.com/Forums/en-US/category/projectserver2010,projectprofessional2010

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm