Multiple Case When

[former_member820000]

Hi experts

i want this code work i don't know how to use "OR" Fuction

CASE WHEN T1."LineTotal"=0 THEN 0 ELSE (-1)*T0."DiscSum" OR CASE WHEN T0."CANCELED"='C' THEN T0.'DiscSum" ELSE T0."DiscSum" END AS "Discount Amount"

[Vitaliy-R]

Could you share the complete SQL query to understand what you are trying to achieve?

[yannmiquel]

Or write in plain text your query? It's hard to understand the left hand side of the OR...

[venkateswaran_k]

Hi

You have to use Union as below to get different case for a single column.

Below is the example. alter it according to your requirement.

SELECT 
CASE WHEN T1."LineTotal"=0 THEN 0 ELSE (-1)*T0."DiscSum" END AS "Discount Amount"
WHERE T1."LineTotal"= 0

UNION

SELECT 
CASE WHEN T0."CANCELED"='C' THEN T0.'DiscSum" ELSE T0."DiscSum" END AS "Discount Amount"
WHERE T0."CANCELED"='C'

Regards,

Venkat