Decode syntax error

[crystalnewbie]

What's wrong with this decode statement? I am getting an invalid relational operator message.

DECODE("PS_PERSONAL_DATA"."STATE", 'CA', 13.5)

I also tried enclosing CA with double quotes.

Reportsmith v.3.1

TIA--

 

[CharlesCook]

DECODE("PS_PERSONAL_DATA"."STATE",'CA',13.5,0)<= add a default here


CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

 

[crystalnewbie]

The same line of code without the default is now working for some reason. All I did was recreate the derived field after I completely logged off our hosted environment. I did try putting a default originally and it wouldn't take that too.

Rather strange...