Hi all,
I’m having a very small calculation problem and I’m just trying to work out what is going on.
When I total my values in a spreadsheet I get the correct answer, but PP is out by one cent.
I’ve messed around with the figures to try to create a minimal use case, and here it is (note the values do not make sense, I am just trying to come up with figures that reproduce the problem).
Here you can see that all figures in the “amount” column are even, yet the “Realized Capital Gains” figure has an odd number of cents (.35) - it is not possible to add even numbers together to get an odd number. The value should be .34 not .35.
Somewhere it is gaining one cent and although it’s only a tiny amount, it makes me wonder if there are other larger calculation errors as well.
If I delete one of the transactions, then the value comes out correct again. Could it be a rounding error somewhere?
I have attached the XML file used for the above screenshot if it is useful.
test.xml (144.9 KB)
Does anyone know what is happening here, and whether it can be fixed so my figures balance?