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

General discussion on all other topics under the sun.

Moderator: Renato

bayu
New MMEX 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)

Post by 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 174 times
User avatar
Renato
MVP MMEX User
Posts: 655
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)

Post by 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.
Renato Forum Administrator
bayu
New MMEX 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

Post by 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
MMEX Developer
Posts: 343
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)

Post by whall3y »

Thanks for the update. Yes we did make a change to fix presentation of large currency values.
AlexPhilip
New MMEX 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)

Post by 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
MVP MMEX 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)

Post by MartinArmstrong »

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).
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?
Post Reply