Grand Total shows wrong calculation (update v1.5.2 Windows)

[bayu]

Hi all,

Just upgraded from 1.5.1 to latest version of 1.5.2 (OS Windows).
I saw that the Grand Total now displaying the wrong number.
Previously its worked fine. Please advise.

Thanks & Regards,
Bayu

PS. Already used MMEX quite sometime, and its really good software

[MartinArmstrong]

Just saying that it displays "the wrong number" does not provide any information that would allow this to be investigated.

Please could you post a screenshot of your Home page showing the balances for each account and the grand total.

The problem you are reporting may relate to a known issue but without more information it's not possible to know.

[Renato]

I assume that these screenshots would be confidential, in such a case you can also send it to us via PM.

[bayu]

Hi Martin, Renato,

I could post the Grand Total line here

Grant_Total.png (7.63 KiB) Viewed 14914 times

The sum up of every accounts seems not correct.
I'll send PM the more complete screenshot. (edit - sorry seems i couldn't send PM - as a new registered user)

Thank you.

[Renato]

Maybe this is the same problem:
viewtopic.php?f=23&t=10415

[bayu]

Hi Renato,

Seems different case on my side.
I found this problem on the stock account.

Stockscalculation2.png (35.84 KiB) Viewed 14892 times

I guess this the one that cause the Grand Total sum up incorrectly.
After checking, somehow the initial value of the stocks changes into negaitve numbers.

Stockscalculation3.png (12.07 KiB) Viewed 14892 times

I'll try to update manually the stock price and inform here.

Thank you.

Bayu

[Nikolay]

Could you , please, try newest code:
https://ci.appveyor.com/project/moneyma ... v5u7rvhvdx

In the properties, you can select the Indian locale and get the following number format: 12,34,456. 89

[bayu]

Hi Nikolay,

I tried the 1.5.3 Beta, but seems still not solve the problem.
When i used the Beta version, the assets in Home Page shown negative values.
If we click the asset from Favorites menu, it will show this

negative_assets.png (19.97 KiB) Viewed 14826 times

After that i tried to delete the assets and its solved the Grand Total calculation problem.
Maybe its related to some way of calculation on the assets.

I roll back to 1.5.1 and its fine, showing back the correct calculation of the Grand Total.
Temporary for the moment i will use the 1.5.1 version.

Thanks for the support. Hope my report could help.

Regards,
Bayu

[Nikolay]

We (development teem) made a lot of changes every day.
Chack history and try
https://ci.appveyor.com/project/moneyma ... ex/history

Under "Job name," choose x64 or Win32 > Artifacts > Portable (version recommended for unstable builds).

[bayu]

Hi All,

Updating on this issue. I successfully reproduce the error, this time using tester data.
Please check on the file below.

Asset List 2021-08-02 054711.png (75.06 KiB) Viewed 14342 times

Detail List Old House 2021-08-02 054736.png (30.3 KiB) Viewed 14342 times

Asset List After Modified 2021-08-02 054840.png (83.2 KiB) Viewed 14342 times

Detail List Old House Modified 2021-08-02 054810.png (30.05 KiB) Viewed 14342 times

Grand Total After Modified 2021-08-02 054946.png (35.29 KiB) Viewed 14342 times

If we return the property without Appreciates 10%, then the total will back to normal number.
Perhaps it will make the problem more clearer.

Thank you all.

[bayu]

This issue still occured in v 1.5.5.
Below is the mmb file so we can test this.

Thanks.

Tester.mmb

(256 KiB) Downloaded 1121 times

[Renato]

My calculation would be:

Starting amount 150,000,000 (Old Big House)

Term 19 years
Interest rate in 10%

Final amount 917,386,356.75
Interest 767,386,356.75

I have not calculated the other positions, probably the total is correct, but the individual current values are not.

[bayu]

Hi all,

thank you for the updates. Today i update to 1.5.7 and the problem is fixed.
Great job. Thanks alot for dev team for the update.

[whall3y]

Thanks for the update. Yes we did make a change to fix presentation of large currency values.

[AlexPhilip]

Use a window sum. This would change the total as filters are applied. If you don't want the total to change when filtering, use FIXED.

WINDOW_SUM(SUM([Sales]))

Depending on what pills are in the view, you may need to Edit Table Calculation - Specific Dimensions - and check all dimensions (basically it's saying ignore these fields for the purpose of summing).

[MartinArmstrong]

Use a window sum. This would change the total as filters are applied. If you don't want the total to change when filtering, use FIXED.

WINDOW_SUM(SUM([Sales]))

Depending on what pills are in the view, you may need to Edit Table Calculation - Specific Dimensions - and check all dimensions (basically it's saying ignore these fields for the purpose of summing).

You may well be right in what you say... but it doesn't appear to have anything to do with this topic (or MMEX at all). Wrong forum perhaps?