whats wrong with this case statement?

CASE
WHEN BRF.COL1 = 'TRUE' THEN
( SUM (CASE WHEN BRF.COL2 = 'XXX' THEN
BRF.COL3 ELSE 0 END ) -1 )
ELSE
( SUM (CASE WHEN BRF.COL3 = ‘YYYY' THEN
BRF.COL4 ELSE 0 END) )
END OUT_COL


The error message is

SQL0104N An unexpected token "END" was found following "IT_Q ELSE 0 END) )".
Expected tokens may include: ")". SQLSTATE=42601

The problem may not be within the snippet you provided. Please post the entire statement.

Andy

I don't think you can put aggregate functions, such as SUM, in the case statement.

That is what I was suspecting, but I wanted to see the entire thing first.

Andy

Yes ARWinner you are right, The column BRF.COL1 i was picking was not present in the group by statement so it was genearting the errors. since the query is working fine now so i can consider that aggregation is possible in the case statements and also the case is possible with aggregation. Anyways, THanks for your help!!!