Re: finding differences in a list of amounts

[Raul Jager <raul@xxxxxxxxxx>]

99% o more that the user's total is wrong, but it is hard to prove, worst part 
is that she will probably get mad once you prove she is wrong.

If you have SQL, you can control your program easily using a SELECT SUM(... 
whit the specified criteria, or write a quick small program to print just the 
total.

Good luck.

El Friday 17 September 2004 15:24, Dan Bale escribió:
> (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.
>