Re: finding differences in a list of amounts

How sure are you that the spreadsheet is correct?  At least half of
these kinds of problems brought to my attention are errors in the user
spreadsheet/query/calculation.

1. How about modifying the report to print the running total, do the
same in Excel, and roll down the list looking to see where they
diverge?

2. If you can recreate the problem on a test system, start modifying
records and seeing if the total gets modified by the same amount. 
When it doesn't, you have found the record that is skipped.

3.  Do some "hashing" -- run the report with small batches of data --
records 1-20, then 21-40, . . . -- this will help you identify the
records being skipped.

Best regards.

On Fri, 17 Sep 2004 16:07:27 -0230, rpower@xxxxxxxxxx <rpower@xxxxxxxxxx> wrote:
> I've never heard of one that could do that.  Have you tried verifying the
> report? Either by copying it to a physical file, or by copying and pasting
> the entire report to excel?  I'd also be on the lookout for negative
> numbers.
> 
> Ron Power
> Programmer
> Information Services
> City Of St. John's, NL
> P.O. Box 908
> St. John's, NL
> A1C 5M2
> Tel: 709-576-8132
> Email: rpower@xxxxxxxxxx
> Website: http://www.stjohns.ca/
> ___________________________________________________________________________
> Success is going from failure to failure without a loss of enthusiasm. -
> Sir Winston Churchill
> 
> "Dan Bale" <dbale@xxxxxxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 17/09/2004 03:54 PM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> 
> To
> <RPG400-L@xxxxxxxxxxxx>
> cc
> 
> 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.
> 
> This e-mail communication and accompanying documents is intended only for the 
> individual or entity to which it is addressed and may contain information 
> that is confidential, privileged or exempt from disclosure under applicable 
> law.  Any use of this information by individuals or entities other than the 
> intended recipient is strictly prohibited.  If you have received this in 
> error, please notify the sender and delete all the copies (electronic or 
> otherwise) immediately.
> --
> 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.
> 
> 



-- 
Tom Jedrzejewicz
tomjedrz@xxxxxxxxx