From: | Andy Anderson <aanderson(at)amherst(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: rounding problems |
Date: | 2008-05-12 18:18:57 |
Message-ID: | 77074003-A28D-4799-A530-10E367AB5FAA@amherst.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can you be more explicit about the rounding that's wrong in Excel?
Are you talking about the ....n5 round-up to n+1 that Excel uses
vs. ....n5 round-to-even n (sometimes called Banker's Rounding)?
-- Andy
On May 12, 2008, at 1:48 PM, Justin wrote:
> I have very annoying problem that i would like to get a work
> around in place so the data entry people stop trying to kill me.
>
> Normally people give quotes out of the price book which was done in
> Excel like 15 years ago and just has been updated over the years.
> the problem is excel is rounding differently than postgres 8.3.1
> (Yes i know Excel rounds incorrectly) which results in normally
> being pennies off but on large qty its usually under a few bucks on
> the postgresql side. We internally don't care but those annoying
> customers scream bloody murder if the quote don't agree to the
> penny on the invoice Even when its to their benefit .
> Has anyone every got Postgresql and Excel to agree on rounding.
> I have checked excel up to Office XP and its still wrong. (open
> office was looked out and the people screamed really loudly NO )
>
> Another annoying thing is the calculators on everyones desk get it
> wrong to if the rounding is turned to 2 places.
> Although my TI-89, and TI-36X calculators agree perfectly with
> postgresql .
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2008-05-12 18:47:11 | Re: Returning RECORD from PGSQL without custom type? |
Previous Message | Tom Lane | 2008-05-12 18:16:06 | Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1 |