[GNC] Rounding & formulas
Adrien Monteleone
adrien.monteleone at lusfiber.net
Tue Dec 22 02:16:33 EST 2020
An important thing to keep in perspective, is this entire thread is
about at most 12¢ per year, and that would be on the far outside of
statistical probability. (Can you get 12 'heads' or 'tails' in a row
flipping a coin?)
Mind you, no one would be prevented from accounting for the alleged
improbable 12¢, but rather, someone might have to adjust a scheduled
transaction *by one digit* to make sure they weren't out of balance that
much - over TWELVE transactions. *IF* twelve monthly transactions in a
row happen to be odd in their totals, and round improperly. (see coin
flip reference above)
No offense intended, but it wouldn't never make sense to track this in a
spreadsheet or otherwise for balancing, JUST CORRECT THE OCCASIONAL ODD
DIGIT!!!
I'm going to stop here, because it is official that any further
discussion is beyond the realm of sanity. Entertaining? Sure.
Productive? Not even close.
Peace Out and Happy Holidays to All,
Adrien
On 12/21/20 9:26 PM, David Carlson wrote:
> I think this rounding problem (if you want to call it that) is not unique
> to Gnucash. You would see the same thing if you were using a spreadsheet,
> for example.
>
> For the particular type of example given, it might make sense to track
> running totals and calculate monthly amounts required to make those running
> totals balance to the desired formula. This would ensure that there was no
> cumulative error from rounding.
More information about the gnucash-user
mailing list