RE: finding differences in a list of amounts

[Mark Allen <mallen@xxxxxxxx>]

Need a supercomputer!!  Even if you had a limited set of 100 records and
limit how many records can make up a total there would be 75,287,520
combinations to try!!!!

Mark Allen
IS Manager
Wilkes Telephone & Electric
11 W. Court Street
Washington, GA 30673
Phone: (706) 678-9565
Cell: (706) 498-7907
Fax: (706) 678-1000


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Dan Bale
Sent: Friday, September 17, 2004 2:24 PM
To: RPG400-L@xxxxxxxxxxxx
Subject: finding differences in a list of amounts


(Cross posting to midrange-l, rpg400-l)

Anybody know of a solution for this?

I have a user that tells me that a report she is getting has the wrong total
amount.  The report shows the detail (a lot of it) but her total that she
keeps track of in a spreadsheet is different from the report's.  Her
spreadsheet doesn't have the detail.  Here's what I have:

$384,582.91 = the report total
$371,448.26 = the user's total
-----------
$ 13,134.65 = difference

Unfortunately, I do not have a single amount of 13,134.65 in my detail.  So,
I must have multiple amounts that total to 13,134.65.

The solution I am looking for is to be able to try all the combinations in
the detail to see what turns up equal to a given total amount.  For example,
if I have the following detail:
     185.69
  11,134.60
     500.03
   4,841.65
   1,500.02
     419.85
etc.
A good tool would be able to find that the 2nd, 3rd, and 5th amounts add up
to the total amount I'm looking for.

Does Excel have a function for something like this?  Or is there to do it on
the 400?  SQL functions?

tia,
db

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.