CharlieFoxtrot
2012-06-07 21:19:06
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?
Martin
2012-06-11 07:50:46
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...
myshop
2012-08-14 06:04:25
Ex tax prices need to be dealt with in a minimum of 4dp of accuracy.. any less and you get rounding errors.