Re: rounding problems

thats how i loaded the price list to start with.  The problems with
sales orders are entered and the automatic pricing kicks in ( the
discounts are calculated * the number or pieces ordered)  it goes to
down the tubes.

I could just rewrite the pricing stored procedures to call a rounding
procedure that would make the results agree with stupid excel :-\

Not the preferred way  but it would make data entry people leave me
alone.  Thanks for the idea.


Christophe wrote:
> Rather than try to recreate Excel's rounding algorithm, perhaps use
> Excel to create a table of input values and results, and load that
> into the database?  It might be easier than trying to back-engineer
> Excel's broken math.