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---