[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