Re: finding differences in a list of amounts -- MIDRANGE-L

As a former RPG developer (in the VSE environment) my first reaction is to suggest that you go to your user and tell her to prove to you that her totals are correct <g>.

But we all know how that would work, so.....

I would have to second Bryon's suggestion. Assuming that you can get the user's data at the detail level then it will establish whether or not you are both processing that data in the same way.

But I would also be inclined to replicate in a spreadsheet what the RPG app is supposed to be doing. That would give you a somewhat 'independent' validation of your RPG-generated results.

Doug

Dan Bale wrote:

(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 Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.