Ramon Quintana

Ramon Quintana

  • NA
  • 404
  • 65.3k

How to do a SUM inside a CASE WHEN clause

Sep 2 2019 1:01 PM
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)