Re: v.1.3.6 - Incorrect balance sometimes shown ...
Posted: Tue Apr 13, 2021 8:40 pm
Hi Nicolay
I think you're right. If the transactions are sorted by date of entry as well as by value this would lead to the anomaly we're seeing and there is no obvious reason for it, i.e. no obvious reason for sorting in the way that the programme does.
As I see it the balance should ONLY be based on the preceding entry, irrespective of the date of entry. For example, if the balance is £500 and the next transaction is a withdrawal of £50 the balance associated with this transaction, i.e. the balance on that row, must show as £450. If there are other transactions on that day, irrespective of their order, each balance must be accurate relative only to the preceding entry.
Using Excel I've set up a simple database with a few entries in the same format as in MMEX and the BALANCE cell has the simple formula:
"= preceding balance minus withdrawal or plus deposit"
If I select the whole table and sort on any column, up or down, the balance in any row is always accurate.
If I do the same with the test account the balance shown in any row is frequently inaccurate relative to that row.
If it would help us get to the bottom of this I am more than happy to send you a copy of the test account I set up and the simple spreadsheet I copied from it. On sorting the test account the balance associated with any entry is frequently wrong while the Excel spreadsheet's balance is always right.
I think you're right. If the transactions are sorted by date of entry as well as by value this would lead to the anomaly we're seeing and there is no obvious reason for it, i.e. no obvious reason for sorting in the way that the programme does.
As I see it the balance should ONLY be based on the preceding entry, irrespective of the date of entry. For example, if the balance is £500 and the next transaction is a withdrawal of £50 the balance associated with this transaction, i.e. the balance on that row, must show as £450. If there are other transactions on that day, irrespective of their order, each balance must be accurate relative only to the preceding entry.
Using Excel I've set up a simple database with a few entries in the same format as in MMEX and the BALANCE cell has the simple formula:
"= preceding balance minus withdrawal or plus deposit"
If I select the whole table and sort on any column, up or down, the balance in any row is always accurate.
If I do the same with the test account the balance shown in any row is frequently inaccurate relative to that row.
If it would help us get to the bottom of this I am more than happy to send you a copy of the test account I set up and the simple spreadsheet I copied from it. On sorting the test account the balance associated with any entry is frequently wrong while the Excel spreadsheet's balance is always right.