3
Answers

How to do a SUM inside a CASE WHEN clause

Ramon Quintana

Ramon Quintana

5y
1.5k
1
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--- 
 
Answers (3)