OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » how to subtract (oracle 10g)

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

how to subtract [message #400393]

Tue, 28 April 2009 00:52

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

How do i subtract the right column and add the left column to the result? /forum/fa/6089/0/

Attachment: sample.JPG
(Size: 22.71KB, Downloaded 1561 times)

Report message to a moderator

how to subtract [message #400395 is a reply to message #400393]

Tue, 28 April 2009 00:55

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

Attachment: sample2.JPG
(Size: 14.11KB, Downloaded 1683 times)

Report message to a moderator

Re: how to subtract [message #400397 is a reply to message #400393]

Tue, 28 April 2009 01:01

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

Senior Member
Account Moderator

What did you try so far?
Your requirement is not clear.
Post a working Test case: create table and insert statements along with the result you want with these data.
Also always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: how to subtract [message #400402 is a reply to message #400397]

Tue, 28 April 2009 01:29

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

Hi, I'm trying to make a report of the movement of inventory so here's the format:

/forum/fa/6093/0/

Attachment: sample4.JPG
(Size: 4.75KB, Downloaded 1645 times)

Report message to a moderator

Re: how to subtract [message #400405 is a reply to message #400402]

Tue, 28 April 2009 01:35

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

Senior Member
Account Moderator

I see the topic has been moved to Reports & Discoverer forum, is this a SQL question or a Reports one?

If this is a SQL question, please do as I asked:

Quote:

Post a working Test case: create table and insert statements along with the result you want with these data.

Regards
Michel

Report message to a moderator

Re: how to subtract [message #400425 is a reply to message #400405]

Tue, 28 April 2009 02:49

leumas
Messages: 22
Registered: March 2009
Location: philippines

Junior Member

It's a report question. I want to be able to manipulate date after query. I hope i'm making sense here.

Report message to a moderator

Re: how to subtract [message #400442 is a reply to message #400425]

Tue, 28 April 2009 04:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you try formula column or analytical LAG/LEAD functions?

Report message to a moderator

Previous Topic:	Showing images in reports 6i from database
Next Topic:	Ascending or Descending

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:42:00 CST 2024