Loading

How to do a SUM inside a CASE WHEN clause

Ramon Quintana

7y1.8k

Hi,

i have created a field called PNL which is part of one main select, and it was created by using CASE WHEN clause,

all is ok but, now i want to add the "Gross_Profit" value inside that field PNL with the CASE WHEN to it can be show or appears in the main Query..

QUESTION:

how can i add the new value "Gross_Profit" within CASE WHEN clause as a part of the PNL field?

I Hope to be clear enough...

Thanks---

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramon Quintana7y ago
Hi AMIT,

Can you be more explicit or show me what i have to do in the Query??

Thank u..
Amit Kumar7y ago
Hi, You will have to use in operator in case when of all those values , then use sum function.
Amit Gupta7y ago
Check this https://stackoverflow.com/a/20935337