OraFAQ Forum: JDeveloper, Java & XML

Home » Developer & Programmer » JDeveloper, Java & XML » Combine Fields

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Combine Fields [message #477381]

Thu, 30 September 2010 07:42

rki1966
Messages: 8
Registered: July 2010
Location: Dallas, TX

Junior Member

I am trying to figure out how to combine the two fields into 1 and sum the profits.

Field1 = Sector1
Field2 = Sector2
Field3 = Secotr1PNL
Field4 = Sector2PNL
Field5 = Currency
Field6 = Region

I want to sum Sector1PNL and Sector2PNL based on Sector1 and Sector2. I want 1 row for each sector.

Example:

Sector1 = CA
Sector2 = CA
Sector1PNL = 500
Sector2 PNL =600

Sector1 = FN
Sector2 = HC
Sector1PNL = 5700
Sector2 PNL =2600

Sector1 = HC
Sector2 = NULL
Sector1PNL = 200
Sector2 PNL = 0

Results:

Sector PNL
CA 1100
FN 5700
HC 2800

Report message to a moderator

Re: Combine Fields [message #477412 is a reply to message #477381]

Thu, 30 September 2010 08:57

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I am trying to figure out how to combine the two fields into 1 and sum the profits

Two fields of what?
Post an example we can run that is post the input and the final output you want from this input.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator