[SQL-Ledger] Re: Bank Account Reconciliation ... Still Unresolved Issues

[WR Consulting]

Rich, one of the things that I found quite surprising about SL when I
first started "peeking under the hood" was its use of a floating-point
type for monetary amounts.  Since most any decent database will
support a fixed-point type, I would've selected that instead.
Fixed-point calculations don't suffer from "drift" like floating-point
ones do.  In fact, the value 0.10 (1/10) in binary floating point is
not an exact value, but an infinitely repeating series.  What does all
of this mean?  I discovered that if enough values are added up, such
was in a reconciliation spanning a long time, they'll drift pretty
badly.
-- 
Best Regards,
Wallace
_______________________________________________
SQL-Ledger mailing list
SQL-Ledger@lists.ledger123.com
http://lists.ledger123.com/mailman/listinfo/sql-ledger