Re: Can Excel Choose from a List What Makes a Particular Total?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I wasn't sure what you meant by ambiguity, but now I see your point. As a
practial real world solution, I agree with everything you've said. BUT the
actual situation isn't exactly as I described it. I described it this way
simply to make what sort of formula/function/algorithm I am looking for
clear. In fact, either of the "ambigious" solutions in your example would
work for my situation. Plus the numbers are mostly (but not all) unique.

"Ron Rosenfeld" wrote:

> Well, let's say your customer sends you a check for $112, and you have the
> following outstanding invoices:
>
> Invoice Amt
> 1 $15
> 2 $10
> 3 $12
> 4 $5
> 5 $7
> 6 $6
> 7 $15
> 8 $15
> 9 $15
> 10 $9
> 11 $13
> 12 $7
> 13 $6
> 14 $6
> 15 $9
> 16 $6
>
> What rule will you use to decide whether to apply the payment to
>
> 1,3..11
> 2,4..10
>
> or some other combination that adds up to $112?
>
> And what if your customer is not applying the same rule, because he disagrees
> with one of the invoices, but hasn't gotten around to informing you yet?
>
> If you can develop clear rules to resolve the inevitable possible ambiguities,
> then you should be able to develop a suitable algorithm. But it seems a lot
> simpler to just apply the payments to the oldest invoices first, absent
> specific instructions from your customer.
>
>
> --ron
>
.

Relevant Pages

  • Re: Business objects, subset of collection
    ... smaller that the corresponding invoice and payment sets in the RDB. ... Lets say you want to find all unpaid invoices. ... for each distinct selection criteria. ... about solving specific customer problems. ...
    (comp.object)
  • Re: Can Excel Choose from a List What Makes a Particular Total?
    ... >> Not easily and there would be a lot of potential ambiguity. ... What rule will you use to decide whether to apply the payment to ... And what if your customer is not applying the same rule, ... with one of the invoices, but hasn't gotten around to informing you yet? ...
    (microsoft.public.excel.misc)
  • Re: help calculation in Query
    ... this is how the table looks, it is sorted by customer number so that all the ... Like to take pay/credit amt from invoice # until ... >>the payment for all customers. ... >>invoices could be applied to send payment. ...
    (microsoft.public.access.queries)
  • Re: Report summary with multiple totals
    ... In a file of invoices, I need a report which lists all the invoices for ... So I've got a summary field which counts invoice_id, ... and a sub-summary for each customer. ... Inv 1 ...
    (comp.databases.filemaker)
  • Re: Rate Customers by Invoiced this Year Field
    ... a negative amount in the "Invoiced This Year" field. ... Dim dbAny As DAO.Database ... rank each customer should receive. ... Is it based on a customer's percentage of total company invoices? ...
    (microsoft.public.access.modulesdaovba)