Re: finding differences in a list of amounts

[Alan Cassidy <steelville@xxxxxxxxxxx>]

> 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.
>  
How many times have we looked for the problem in our code and the 
problem turned out to be some expectation of the user, or some "little" 
detail they forgot to tell us..

This has probably already been checked, but I didn't see it posted, so...

Your report totals come from a file, I will presume, and in these cases, 
frequently, I'll find a field in the record format that is not often 
used. For example, we have an order file. Included are sales invoices, 
and credit memos both. Some update inventory counts, some don't. Among 
the credit memos, there are some of them that have uncommon "reason 
codes". There are sometimes very special credit codes. There sometimes 
is a rebate amount.

Select Flag1, Flag2, Reason-code, Total( ExtendedCost ), Total( ExtPrice 
), Total( ExtPrice - ExtendedCost )
From FileA
Group by Flag1, Flag2, Reason-code
Order by Flag1, Flag2, Reason-code.

By the way, that sure was a creative way to work with it, Joe, if he has 
to go about it by brute force.

-- Alan