ReportBuilder Formula Help

[pwomack]

Using SQL Server 2005 ReportBuilder.

I currently have this formula field and it works:

IF((Region = "NW"),"West & New West",RegionName)

I want to modify the formula field to include an additional region value, such as:

IF((Region = "NW" OR "PD"),"West & New West",RegionName)

But this does not work. I get a syntax error saying: expected ).

Help Please.

 

[paulkeys]

haven't got access to reportbuilder at the moment to check, but it may be that you can use;

IF(OR(Region="NW",Region="PD"),"West & New West",RegionName)

 

[pwomack]

Great! That worked. Thanks.