Spent a LOT of time trying to find a error.
? 6313*.22 && =1388.86
however I need to work to 4 dec points
thus
? INT(6313.0000 * 22.00/100*10000)/10000 && =1388.8599
Which I FLOOR to 1388.85
once I found the prob, fixed it by multiplying first
thus
? INT(10000*6313.0000*22.00/100)/10000 && =1388.8600
I've spent WAY too much time chasing a penny here and there. I've
found that it is best to convert the currency field to a numeric
first. Actually, I've found that it is best to avoid the currency
data type like the plague.
--
[EMAIL PROTECTED]
www.mymacaronilife.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
