Home » Developer & Programmer » Reports & Discoverer » how to subtract (oracle 10g)
how to subtract [message #400393] Tue, 28 April 2009 00:52 Go to next message
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 1565 times)
how to subtract [message #400395 is a reply to message #400393] Tue, 28 April 2009 00:55 Go to previous messageGo to next message
leumas
Messages: 22
Registered: March 2009
Location: philippines
Junior Member
/forum/fa/6092/0/
  • Attachment: sample2.JPG
    (Size: 14.11KB, Downloaded 1688 times)
Re: how to subtract [message #400397 is a reply to message #400393] Tue, 28 April 2009 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
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
Re: how to subtract [message #400402 is a reply to message #400397] Tue, 28 April 2009 01:29 Go to previous messageGo to next message
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 1649 times)
Re: how to subtract [message #400405 is a reply to message #400402] Tue, 28 April 2009 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
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
Re: how to subtract [message #400425 is a reply to message #400405] Tue, 28 April 2009 02:49 Go to previous messageGo to next message
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.
Re: how to subtract [message #400442 is a reply to message #400425] Tue, 28 April 2009 04:18 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try formula column or analytical LAG/LEAD functions?
Previous Topic: Showing images in reports 6i from database
Next Topic: Ascending or Descending
Goto Forum:
  


Current Time: Sat Dec 07 05:36:42 CST 2024