| Subtract Record [message #341227] |
Sun, 17 August 2008 22:30  |
sweetkhaliq
Messages: 200
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 #341287 is a reply to message #341227] |
Mon, 18 August 2008 03:52  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
