Page 1 of 1

Why Does ISC Use Four Decimal Places?

Posted: Thu Jun 07, 2012 10:19 pm
by CharlieFoxtrot
It's something I've always wondered about. Is there a practical reason why all of the prices (and many other numeric values) are saved in the database with 4 decimal places?

For example: "9.9500" instead of "9.95"

Is this an industry standard that Interspire was following? Or is it just a matter of the programmer's preferences?

Re: Why Does ISC Use Four Decimal Places?

Posted: Mon Jun 11, 2012 8:50 am
by Martin
I suppose it's possible that things like some currencies have hyper inflation and there's always some numpty who wants to use KG as their weight measure and then has lots of items weighing a couple of grams.

Probably just a play it safe thing though...

Re: Why Does ISC Use Four Decimal Places?

Posted: Tue Aug 14, 2012 7:04 am
by myshop
Ex tax prices need to be dealt with in a minimum of 4dp of accuracy.. any less and you get rounding errors.