Missing Right Parenthesis??

[abowling]

What is wrong with this derived field? I keep getting 'missing right parenthesis':

SUM("CASE TABLE_NAME.DED_CODE"
WHEN 'TRC' THEN "TABLE_NAME_AMOUNT"
ELSE 0 END)

 

[abowling]

THAT FIRST LINE SHOULD BE:

SUM(CASE "TABLE_NAME.DED_CODE

 

[CharlesCook]

'missing right parenthesis' is like a default error message.

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

 

[abowling]

Yes, I have gotten that before, when there was something wrong with the derived field (not necessarily missing right parenthesis). Do you know what is wrong with the derived field though?

 

[CharlesCook]

Like abardel said it should look like this:


SUM(CASE "TABLE_NAME.DED_CODE"
WHEN 'TRC'
THEN "TABLE_NAME_AMOUNT"
ELSE
0
END)

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