How to create a sum value ??

Question

Hi, I have a field 'PNL' which has several values, i want to create another value of it with the result of add two values of it, for example: newvalue=cost+financial_Income Thank a lot you mates!!!

Sonu Gupta · Answer

Hi, Used the UNION like this - SELECT PNL,SUM(profit_center_local_currency) AS SUM_PROFIT FROM QueryBase_PyL5089_Rys_UNION GROUP BY PNL UNION SELECT 'newvalue' AS PNL SUM(profit_center_local_currency) AS SUM_PROFIT FROM QueryBase_PyL5089_Rys_UNION WHERE PNL IN ('cost','financial_Income')

Ramon Quintana · Answer

Hi Sonu, How can i to add this new vale as a part of the PNL field in order to this be show when i run the main query?? for example add another case when in the main case when which created the PNL field. Thank u

Ramon Quintana · Answer

Hi Mr. Sonu In other words this PNL field is part of one main select and it was created by using CASE WHEN clause, so now i want to add the "new Value" inside the main Query For example: how can i add the new value within CASE WHEN clause as a part of the PNL field? I Hope to be clear enough... Thanks again...

Ramon Quintana · Answer

Thank Mr Sonu. It works perfect.. I really apreciatte your response... Grettings,

Ramon Quintana · Answer

What i mean is: To create a "New Value" record number 17 in this case, of field PNL as a result of to add values of records Cost + Financial income, net for example: NewValue= 589979239877.38 + 5274955325.04 = XXXXX

How to create a sum value ??

Answers (5)