Grand Total shows wrong calculation (update v1.5.2 Windows)
Moderator: Renato
-
- New User
- Posts: 7
- Joined: Tue Jun 08, 2021 11:17 pm
- Are you a spam bot?: No
Grand Total shows wrong calculation (update v1.5.2 Windows)
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
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
-
- MVP User
- Posts: 300
- Joined: Tue Mar 02, 2021 10:24 am
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
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.
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.
-
- MVP User
- Posts: 681
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
I assume that these screenshots would be confidential, in such a case you can also send it to us via PM.
Renato Forum Administrator
-
- New User
- Posts: 7
- Joined: Tue Jun 08, 2021 11:17 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Hi Martin, Renato,
I could post the Grand Total line here
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.
I could post the Grand Total line here
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.
You do not have the required permissions to view the files attached to this post.
Last edited by bayu on Wed Jun 09, 2021 3:30 pm, edited 1 time in total.
-
- MVP User
- Posts: 681
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Maybe this is the same problem:
viewtopic.php?f=23&t=10415
viewtopic.php?f=23&t=10415
Renato Forum Administrator
-
- New User
- Posts: 7
- Joined: Tue Jun 08, 2021 11:17 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Hi Renato,
Seems different case on my side.
I found this problem on the stock account.
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. I'll try to update manually the stock price and inform here.
Thank you.
Bayu
Seems different case on my side.
I found this problem on the stock account.
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. I'll try to update manually the stock price and inform here.
Thank you.
Bayu
You do not have the required permissions to view the files attached to this post.
Last edited by bayu on Thu Jun 10, 2021 1:32 am, edited 2 times in total.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
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
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
-
- New User
- Posts: 7
- Joined: Tue Jun 08, 2021 11:17 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
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 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
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 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
You do not have the required permissions to view the files attached to this post.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
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).
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).
-
- New User
- Posts: 7
- Joined: Tue Jun 08, 2021 11:17 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Hi All,
Updating on this issue. I successfully reproduce the error, this time using tester data.
Please check on the file below.
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.
Updating on this issue. I successfully reproduce the error, this time using tester data.
Please check on the file below.
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.
You do not have the required permissions to view the files attached to this post.
-
- New User
- Posts: 7
- Joined: Tue Jun 08, 2021 11:17 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
This issue still occured in v 1.5.5.
Below is the mmb file so we can test this.
Thanks.
Below is the mmb file so we can test this.
Thanks.
You do not have the required permissions to view the files attached to this post.
-
- MVP User
- Posts: 681
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
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.
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.
Renato Forum Administrator
-
- New User
- Posts: 7
- Joined: Tue Jun 08, 2021 11:17 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows) - FIXED
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.
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.
-
- Developer
- Posts: 345
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
Thanks for the update. Yes we did make a change to fix presentation of large currency values.
-
- New User
- Posts: 1
- Joined: Sun Sep 26, 2021 6:52 pm
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
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).
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).
-
- MVP User
- Posts: 300
- Joined: Tue Mar 02, 2021 10:24 am
- Are you a spam bot?: No
Re: Grand Total shows wrong calculation (update v1.5.2 Windows)
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?AlexPhilip wrote: ↑Tue Sep 28, 2021 4:11 am 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).