Home » Developer & Programmer » Forms » Subtract Record
Subtract Record [message #341227] Sun, 17 August 2008 22:30 Go to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear Members
I am using forms 6i. I have a master detail form. In which there is only three records for each master record. The detail records can not exceeds three records. Problem is that i want to subtract 2nd row values from the 1st row and add 3rd rows values in it. And show the balance in summary columns. scenario is like this 1st and third rows values should be added and 2nd rows values should be subtracted.
One possible solution is that we store the second row values with negative sign. Now when we take sum of detail block it will show exact result.

But i do not want to add negative sign with the 2nd row values is there any other solution.

thanks & regards

[Updated on: Sun, 17 August 2008 22:30]

Report message to a moderator

Re: Subtract Record [message #341232 is a reply to message #341227] Sun, 17 August 2008 23:05 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Records in a table are like balls in a basket.
If there are 3 red balls in the basket, please identify which red ball is first & which of the 2 remaining balls is last or 3rd ball.

[Updated on: Sun, 17 August 2008 23:05] by Moderator

Report message to a moderator

Re: Subtract Record [message #341287 is a reply to message #341227] Mon, 18 August 2008 03:52 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
i do not want to add negative sign with the 2nd row values is there any other solution.

Once you uniquely identify order of these rows, you might create "hidden" items (invisible, not displayed) which would hold values having positive or negative sign. Create a summary based on these "hidden" items instead of displayed ones.
Previous Topic: string problem
Next Topic: Hardware Inventory
Goto Forum:
  


Current Time: Sun Dec 04 20:41:19 CST 2016

Total time taken to generate the page: 0.08434 seconds