I need a way to sum a field until I get a specific value. I have a subset of records ~8-20 sales records with 2 different discount rates applied on the same invoice. I know the percentage of the discounts is say 10% for a toal of $25.20 and 40% for a total
of 36. Given this I know that the item(s) receiving 10% discount totaled $252 and the item(s) that recieved 40% discount totaled $90. Does anyone have a way to take this information and find the transacation(s) that match the total dollars. It does not have
to be 100% accurate but I can only apply one discount to each transaction record. Any insight you may have on this will be greatly apprecaited. Thanks.
View Complete Post