DSXchange

ray.wurlod wrote:Is there not an optional "Decimal Type" property where you can set precision and scale?

I've worked at banks for most of my career. From a Savings Bank to the NY Fed., all use 'decimal' types for dollars and cents, and all calculations are done BCD. It's probably one of the greatest reasons that banks are still using COBOL. It doesn't matter what you do with rounding or whatever, when you're calculating interest out to 10-11 decimal places(compounding factors), there's no way a conversion to and from float or doubles will give you the correct answer 100% of the time.
And that's the biggest problem...unless a bank want's to end up in court, the calculations have to be right 100% of the time.

Ande